RE: what roles have been granted to a user?

I always use "select * from dba_objects where object_name like '%ROLE%'; = "
when I am not sure what it was but likely has the word role in it.

Doing this will give you things like "DBA_ROLES" and "DBA_ROLE_PRIVS". Figure it out from there :-)

• Babette

-----Original Message-----

From: oracle-l-bounce_at_freelists.org =
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of sol beach Sent: February 25, 2005 2:18 PM
To: Oracle-L Freelists
Subject: what roles have been granted to a user?

I know I should know how to do this, but I'm suffereing from senoritis.

What query will show me which ROLEs have been GRANTed to a specific = user?
I can't seem to find the VIEW/TABLE which contains this information.

TIA!
--

http://www.freelists.org/webpage/oracle-l
--

http://www.freelists.org/webpage/oracle-l Received on Fri Feb 25 2005 - 14:27:31 CST