OraFAQ Forum: Security » SELECT access to VIEWS through ROLES

Home » RDBMS Server » Security » SELECT access to VIEWS through ROLES

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

SELECT access to VIEWS through ROLES [message #162136]

Wed, 08 March 2006 22:35

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

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

Report message to a moderator

Previous Topic:	Security and XA permissions
Next Topic:	username with @

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 11 19:58:16 CST 2024