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
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:...
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
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
Member
Got it thanks.
Previous Topic: Hiding a Field.
Next Topic: sucurity on view
Goto Forum:
  


Current Time: Fri Mar 29 04:08:43 CDT 2024