Re: Nested roles - PL/SQL proc

From: Oradba Linux <oradba_linux_at_attbi.com>
Date: Wed, 04 Jun 2003 16:53:38 GMT
Message-ID: <pan.2003.06.04.16.55.13.276912@attbi.com>

On Wed, 04 Jun 2003 07:15:20 +0000, Jeff Bock wrote:

> 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

May be this link could help you ......
http://asktom.oracle.com/pls/ask/f?p=4950:8:255024707240464514::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:853427230099, Received on Wed Jun 04 2003 - 11:53:38 CDT