Re: Nested roles - PL/SQL proc

I would gladly stick with the data dictionary if I could, but it's not providing me with enough information - it doesn't detail the nesting and trying to trace through the 20,000+ roles & privs to find what has been assigned is a little cumbersome.

I "could" write a recursive procedure against it, but I'm no PL/SQL guru and I figured someone out there has already done it...

Thanks for the help though,

• Jeff