How To Assign Debug Privileges to a User

Q

How To Assign Debug Privileges to a User? - Oracle DBA FAQ - Introduction to Oracle SQL Developer

✍: FYIcenter.com

A

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.

2007-04-28, 5940👍, 0💬