OraFAQ Forum: Security » how to view object granted in a Role

Home » RDBMS Server » Security » how to view object granted in a Role

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

how to view object granted in a Role [message #246546]

Thu, 21 June 2007 05:06

win3vin
Messages: 35
Registered: April 2007
Location: Malaysia

Member

Hi,

I have created a few roles and granted >1000 objects into the roles. instead of using the DBCA to view one by one, is there any way to query what are the objects granted to the role?
Are there any static dictionary view for this kind of query?

Your feedback is very much appreciate. Thanks

Report message to a moderator

Re: how to view object granted in a Role [message #246550 is a reply to message #246546]

Thu, 21 June 2007 05:12

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

select * from DBA_ROLE_PRIVS;

And

select * from ROLE_TAB_PRIVS

Combine these two..

[Updated on: Thu, 21 June 2007 05:15]

Report message to a moderator

Re: how to view object granted in a Role [message #246776 is a reply to message #246550]

Thu, 21 June 2007 20:53

win3vin
Messages: 35
Registered: April 2007
Location: Malaysia

Member

hi,

thanks.
DBA_ROLE_PRIVS is to check roles granted. I would to check what are the objects granted to the role instead? any idea?

Report message to a moderator

Re: how to view object granted in a Role [message #246777 is a reply to message #246550]

Thu, 21 June 2007 21:11

win3vin
Messages: 35
Registered: April 2007
Location: Malaysia

Member

Got it thanks.

Report message to a moderator

Previous Topic:	Hiding a Field.
Next Topic:	sucurity on view

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jan 26 02:25:38 CST 2026