Verificar Grants

SELECT * FROM dba_role_privs WHERE granted_role = 'DBA';

SELECT 'REVOKE DBA FROM ' || grantee || ';' FROM dba_role_privs WHERE granted_role = 'DBA' AND grantee NOT LIKE '%SYS%';


SELECT 'REVOKE ' || GRANTED_ROLE || ' FROM ' || grantee || ';' FROM dba_role_privs WHERE grantee IN ('BACKUP','SYSTEM');


select 'grant '||privilege||' on '||owner||'.'||table_name||' to '||grantee||';' from dba_tab_privs where grantee like 'SOF%' order by grantee;