Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: finding composition of a role
Doug Cowles <dcowles_at_bigfoot.com> wrote in message news:37AF4060.5D676CA0_at_bigfoot.com...
> What view do I query to find out what a particular role contains?
> Specifically interested in "SELECT_CATALOG_ROLE"
> Is the breakdown available in some other view?
>
DBA_ROLE_PRIVS However, if you want to generate a hierarchical query, you must query SYS.SYSAUTH$. Received on Tue Aug 10 1999 - 13:37:08 CDT