Check Developer Privileges on Shared Systems

SELECT GRANTEE||': '||PRIVILEGE FROM DBA_SYS_PRIVS WHERE
(PRIVILEGE LIKE 'CREATE%' OR PRIVILEGE LIKE 'ALTER%'OR PRIVILEGE LIKE 'DROP%')
AND PRIVILEGE<>'CREATE SESSION'
AND GRANTEE NOT IN
('SYS','SYSTEM','ANONYMOUS','AQ_ADMINISTRATOR_ROLE','MTSSYS',
'CONNECT','CTXSYS','DBA','IMP_FULL_DATABASE','MDSYS','ODM',
'ODM_MTR','OEM_MONITOR','OLAPSYS','OLAP_DBA','ORDPLUGINS','ORDSYS',
'RECOVERY_CATALOG_OWNER','RESOURCE','SYS','WKPROXY','WKSYS',
'WKUSER','WMSYS','XDB','TIMESERIES_DEVELOPER','TIMESERIES_DBA',
'LBACSYS','DBSNMP','OLAP_USER') order by grantee;