Re: Problem with roles

From: Brian Peasland <peasland_at_edcmail.cr.usgs.gov>
Date: Fri, 20 Aug 1999 13:33:54 GMT
Message-ID: <37BD5942.EC1F0004@edcmail.cr.usgs.gov>

To get the roles granted to any user, query the DBA_ROLE_PRIVS where GRANTEE='user_in_question'.

HTH,
Brian

dm_zo_at_my-deja.com wrote:
>
> Hi,
> I have a little problem:
> I need to select in PL/SQL package roles granted
> to the current user.
> But if I use view "user_role_privs" I receive
> roles granted to package creator.
> What can I use instead of "user_role_privs"?
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Fri Aug 20 1999 - 08:33:54 CDT