Re: finding composition of a role

From: Doug Cowles <dcowles_at_bigfoot.com>
Date: Tue, 10 Aug 1999 16:01:31 -0400
Message-ID: <37B0851B.7DF855A2@bigfoot.com>

I tried doing a select on dba_role_privs but the grantee list doesn't contain any of Oracle's preset roles, just users and user made roles...

Sybrand Bakker wrote:

> select * from dba_role_privs
> select * from dba_role_roles shows which roles have been granted to roles.
> This might be also necessary.
>
> Hth,
>
> Sybrand Bakker, Oracle DBA
>
> 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?
> >
> > - Dc.
> >
Received on Tue Aug 10 1999 - 15:01:31 CDT