RE: what roles have been granted to a user?
- From: <babette.turnerunderwood@xxxxxxxxxxxxx>
- To: <sol.beach@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 25 Feb 2005 14:24:26 -0500
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@xxxxxxxxxxxxx =
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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!
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
