Home » RDBMS Server » Security » how to view object granted in a Role
how to view object granted in a Role [message #246546] Thu, 21 June 2007 05:06 Go to next message
win3vin
Messages: 35
Registered: April 2007
Location: Malaysia
Karma: 0
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
Re: how to view object granted in a Role [message #246550 is a reply to message #246546] Thu, 21 June 2007 05:12 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Karma: 0
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 Go to previous messageGo to next message
win3vin
Messages: 35
Registered: April 2007
Location: Malaysia
Karma: 0
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?
Re: how to view object granted in a Role [message #246777 is a reply to message #246550] Thu, 21 June 2007 21:11 Go to previous message
win3vin
Messages: 35
Registered: April 2007
Location: Malaysia
Karma: 0
Member
Got it thanks.
Previous Topic: DDL auditing
Next Topic: Oracle Label Security in J2EE?
Goto Forum:
  


Current Time: Tue Aug 22 10:06:46 CDT 2017

Total time taken to generate the page: 0.11461 seconds