用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也授予该用户。