Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: finding composition of a role
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 Mon Aug 09 1999 - 16:44:00 CDT
![]() |
![]() |