Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Nested roles - PL/SQL proc

Nested roles - PL/SQL proc

From: Jeff Bock <jeffbb88_at_hotmail.com>
Date: 4 Jun 2003 07:15:20 -0700
Message-ID: <5b8b1052.0306040615.8f1bac6@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 Received on Wed Jun 04 2003 - 09:15:20 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US