SELECT * FROM DBA_SYS_PRIVS D WHERE D.PRIVILEGE = 'CREATE ANY PROCEDURE' OR D.PRIVILEGE = 'EXECUTE ANY PROCEDURE' OR D.PRIVILEGE = 'DEBUG ANY PROCEDURE'
http://blog.163.com/xiaomi_8266/blog/static/720764272010323112252489/ SELECT * FROM role_sys_privs WHERE PRIVILEGE IN ('create any PROCEDURE', 'ALTER ANY PROCEDURE','DEBUG ANY PROCEDURE','EXECUTE ANY PROCEDURE')
SELECT *
FROM DBA_SYS_PRIVS D
WHERE D.PRIVILEGE = 'CREATE ANY PROCEDURE' OR
D.PRIVILEGE = 'EXECUTE ANY PROCEDURE' OR
D.PRIVILEGE = 'DEBUG ANY PROCEDURE'
SELECT * FROM role_sys_privs WHERE PRIVILEGE IN ('create any PROCEDURE', 'ALTER ANY PROCEDURE','DEBUG ANY PROCEDURE','EXECUTE ANY PROCEDURE')