select grantee, privilege from dba_sys_privs
where (privilege like 'CREATE%' or privilege like 'ALTER%'
or privilege <> 'DROP%')
and privilege <> 'CREATE SESSION'
and grantee not
in ('SYS', 'SYSTEM', 'ANONYMOUS', 'AQ_ADMINISTRATOR_ROLE', 'MTSSYS',
'CONNECT', 'CTXSYS', 'DBA', 'IMP_FULL_Database', 'MDSYS', 'ODM',
'LBACSYS', 'ODM_MTR', 'OEM_MONITOR', 'OLAPSYS', 'OLAP_DBA', 'ORDPLUGINS',
'ORDSYS', 'RECOVERY_CATALOG_OWNER', 'RESOURCE', 'SYS', 'WKPROXY',
'WKSYS', 'WKUSER', 'WMSYS', 'XDB', 'TIMESERES_DEVELOPER', 'TIMESERIES_DBA')
order by 1, 2 asc;