Re: Nested roles - PL/SQL proc

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 4 Jun 2003 12:50:44 -0700
Message-ID: <92eeeff0.0306041150.182e526a@posting.google.com>

jeffbb88_at_hotmail.com (Jeff Bock) wrote in message news:<5b8b1052.0306040615.8f1bac6_at_posting.google.com>...
> Hi,
>
> I'm trying to determine what roles a user has been assigned (whether
> directly or indirectly), and it seems the only proper way to do it is
> through a recursive PL/SQL proc.
>
> I'm sure someone out there has already written one, and I would
> appreciate it if you could post it.
>
> Many thanks,
>
> Jeff

SELECT granted_role
FROM sys.dba_role_privs
WHERE grantee = '&User_Name';

Regards
/Rauf Sarwar Received on Wed Jun 04 2003 - 14:50:44 CDT