Home » RDBMS Server » Security » SELECT access to VIEWS through ROLES
SELECT access to VIEWS through ROLES [message #162136] Wed, 08 March 2006 22:35 Go to next message
manwadkar
Messages: 104
Registered: September 2005
Location: Washington DC
Senior Member

I want to give SELECT access to VIEWS to roles and then roles to users. Is this possible? I think not if these VIEWS are used in procedure/functions/packages. Just I want to confirm it. Thanks in advance.

[Updated on: Thu, 09 March 2006 03:20]

Report message to a moderator

Re: SELECT access to VIEWS through ROLES [message #162951 is a reply to message #162136] Tue, 14 March 2006 05:12 Go to previous message
JSI2001
Messages: 1016
Registered: March 2005
Location: Scotland
Senior Member
Yes, you are correct. The view must be explicitly granted to the user (or the user needs the select any table priv.

Jim
Previous Topic: Security and XA permissions
Next Topic: username with @
Goto Forum:
  


Current Time: Thu Mar 28 05:12:15 CDT 2024