Re: Finding empty Role(s)

select role from dba_roles
minus
select granted_role from dba_role_privs;

ROLE

On 5/12/20 10:13 AM, Lyall Barbour wrote:
> Hello everyone,
>   I'm either Googling the wrong keywords, or thinking about this too
> hard.  I just revoked a ton of object privs from a non-prod database
> in preparation for doing a decommission of a specific schema in a
> large database for the Business.  I'm now trying to find any Roles
> that are empty because of my revoking.  Does anyone have a script to
> do this?
> TIA
> Lyall Barbour
> -- http://www.freelists.org/webpage/oracle-l

-- 
Mladen Gogala
Database Consultant
Tel: (347) 321-1217


--
http://www.freelists.org/webpage/oracle-l