DBA FUS‎ > ‎

Role Permissions

posted Sep 13, 2010, 6:16 AM by Sachchida Ojha
select grantee,owner,table_name from dba_tab_privs
               where privilege in ('ALTER','REFERENCES','INDEX')
               and grantee not in ('DBA','SYSTEM','LBACSYS','XDBADMIN','XDB_ADMIN')
               and table_name not in ('SDO_IDX_TAB_SEQUENCE','XDB$ACL')
      and grantee not in (select grantee from dba_role_privs where granted_role='DBA')
      and grantee not in (select owner from dba_objects);
Comments