RE: what roles have been granted to a user?

From: Bellows, Bambi <bbellows_at_usg.com>
Date: Fri, 25 Feb 2005 12:27:27 -0700
Message-ID: <20942DC78B4BBB49A1567DB0E5E81EB50F10F8CB@dctr-exbe-001.usg.net>

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] 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!
--

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

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