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.

 

Set Up Breakpoints in Debug Mode in Oracle

Run Stored Procedures in Debug Mode in Oracle

Introduction to Oracle SQL Developer

⇑⇑ Oracle Database Tutorials

2019-01-12, 4557🔥, 0💬