Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Nested roles - PL/SQL proc
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
![]() |
![]() |