Assign Debug Privilege to a User in Oracle

Q

How To Assign Debug Privileges to a User in Oracle?

✍: 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.

 

Introduction to Oracle SQL Developer

⇒⇒Oracle Database Tutorials

2016-10-17, 125👍, 0💬