Re: finding composition of a role

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Mon, 9 Aug 1999 23:44:00 +0200
Message-ID: <934235050.11024.0.pluto.d4ee154e@news.demon.nl>

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