Roles/Priviliges neede for Dedug

[kapustis]

Hi,

I have a "debug connect session" and
can run debugger, but it does not step-in -
does not show code of function.

What did I miss ?

Rgds,
Sam

 

[rbrooker]

you need to add debug information. right click on the object in the browser and select "Add Debug Information".

 

[kapustis]

Thank you rbrooker - it works.

 

[he]

Sorry, but it doesn't work for me.

Here my test-case:

• The user "developer" is the owner of the package "my_pack".
• The package "my_pack" is compiled with debug informations.
• The user "my_user" has the privileges for "my_pack" and all objects that are referenced by "my_pack".
• Both users ("developer" and "my_user") have the "debug connect session" privilege.

Now, user "my_user" has a test script in a PL/SQL Developer Test-Window which calls "my_pack.proc1". When the script is started with "F9" ("start debugger") the debugger would not step-in "my_pack.proc1".

When user "developer" starts the same test script, the debugger would step in "my_pack.proc1".

Do you have any ideas, how user "my_user" can debug the test script with step-in "my_pack.proc1"?

Thanks, he

 

[Marco Kalter]

Another user's package/type bodies will only be visible if you have select privileges on the sys.dba_objects and sys.dba_source views. The "Use DBA views if available" preference (Tools > Preferences > Oracle / Options tab page) needs to be enabled though. To debug another user's package bodies you additionally need the "create any procedure" system privilege. This is an Oracle Debug requirement.