Assign Debug Privilege to a User in Oracle


How To Assign Debug Privileges to a User in Oracle?



In order to run SQL Developer in debug mode, the session must be connected with a user who has debug privileges. The following script shows you how to assign debug privileges:

  • Connect to the default database, XE, as SYSTEM.
  • Run "GRANT debug any procedure, debug connect session TO HR;".
  • Re-connect to the default database, XE, as HR.

You new session should have enough privileges to debug stored procedures now.


Introduction to Oracle SQL Developer

⇒⇒Oracle Database Tutorials

2019-01-12, 1062👍, 0💬