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); |
DBA FUS >