Tuesday, October 27, 2009

Granting Debugging priviliges in oracle

In PL/SQL developer there is an option for testing the stored programs(Procedures/Functions/Packages).

In test mode the stored programs can be debugged step by step. To do that the user should have Debugging priviliges.

The command for granting debugging priviliges is

GRANT DEBUG ANY PROCEDURE , DEBUG CONNECT SESSION TO USER_NAME

No comments:

Powered By Blogger