用toad时,不用DBA权限就可以调试存储过程的方法
1.
CREATE ROLE TOAD_PLSQL_DEV_SENIOR NOT IDENTIFIED;
GRANT DEBUG ANY PROCEDURE TO TOAD_PLSQL_DEV_SENIOR;
GRANT EXECUTE ON SYS.DBMS_DEBUG_JDWP TO TOAD_PLSQL_DEV_SENIOR;
GRANT DEBUG CONNECT SESSION TO TOAD_PLSQL_DEV_SENIOR;
GRANT TOAD_PLSQL_DEV_SENIOR TO user_name;
2. 用user_name登录toad后就可以调试,如果还不能,则将resource也授予该用户