Such as: the PL/SQL developer to see if the current user has the authority to create debug call a stored procedure?

CodePudding user response:

Select * from user_role_privs

CodePudding user response:

Log in to the pl/SQL system permissions have enter the Users menu for the user (DEBUG CONNECT SESSION) as shown in figure:

CodePudding user response:

SELECT * FROM ALL_SOURCE WHERE NAME='PROC_TEST'

CodePudding user response:

 
SELECT * 
The FROM DBA_SYS_PRIVS D 
WHERE D.P RIVILEGE='CREATE ANY PROCEDURE OR 
D.P RIVILEGE='an EXECUTE ANY PROCEDURE OR 
D.P RIVILEGE='DEBUG ANY PROCEDURE' 

CodePudding user response:

http://blog.163.com/xiaomi_8266/blog/static/720764272010323112252489/

 SELECT * FROM role_sys_privs WHERE PRIVILEGE IN (' create any PROCEDURE ', 'the ALTER any PROCEDURE', 'the DEBUG any PROCEDURE', 'the EXECUTE any PROCEDURE')