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