RE: what roles have been granted to a user?
- From: "Bellows, Bambi" <bbellows@xxxxxxx>
- To: <sol.beach@xxxxxxxxx>, "Oracle-L Freelists" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 25 Feb 2005 12:27:27 -0700
Well, here's what I do when I get a burst of senioritis...
select view_name
from dba_views=20
where view_name like 'DBA%PRIV%'
or view_name like 'V%PRIV%';
That should send you on your way pretty easily...
Good luck!
Bambi.
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of sol beach
Sent: Friday, February 25, 2005 1: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: