Oracle SQL Developer - How To Assign Debug Privileges to a User

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, 5985👍, 0💬

How To Set Up Breakpoints in Debug Mode
How To Set Up Breakpoints in Debug Mode? - Oracle DBA FAQ - Introduction to Oracle SQL Developer To debug a stored procedure, you need to set breakpoints at different statements in the code block, so that execution will be stopped at the statement marked with a breakpoint. When execution is stopped,... 2007-04-28, 6692👍, 0💬

How To Assign Debug Privileges to a User
How To Assign Debug Privileges to a User? - Oracle DBA FAQ - Introduction to Oracle SQL Developer 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 dat... 2007-04-28, 5986👍, 0💬

How To Run a Stored Procedure Interactively
How To Run a Stored Procedure Interactively? - Oracle DBA FAQ - Introduction to Oracle SQL Developer If have an existing stored procedure and you want to run it interactively, the tutorial steps listed below will help you out: Open you connection name, like Local_XE. Open Procedures. Right-click the... 2007-04-28, 4925👍, 0💬

What Do You Think about Oracle SQL Developer
What Do You Think about Oracle SQL Developer? - Oracle DBA FAQ - Introduction to Oracle SQL Developer To conclude this introductory FAQ collection, you should think about Oracle SQL Developer in comparison with other client tools like SQL*Plus and Oracle Web interface. SQL Developer is definitely be... 2007-04-28, 4344👍, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.