Debugging other user's procedures

Toad for Oracle
1

Hi …

I am an oracle DBA and i am facing a major problem to deal with.

I have a user called user_name and i gave it these permissions :

GRANT ALTER SESSION TO user_name;

GRANT CREATE SESSION TO user_name;

GRANT EXECUTE ON DBMS_DEBUG to user_name;

GRANT ALTER ANY PROCEDURE TO user_name;

GRANT CREATE ANY PROCEDURE TO user_name;

GRANT DEBUG ANY PROCEDURE TO user_name;

GRANT DEBUG CONNECT SESSION TO user_name;

But whenever i am trying to debug a procedure from another user, toad return the following oracle error :

PLS-00904: insufficient privilege to access object ***********

My toad version is : 11.6

My oracle version is : 11G R2

can anyone please address what i am missing here? it became frustrating …

Thanks

2

Do you have privileges to execute the procedure?

You may also need GRANT SELECT ON DBA_SOURCE to user_name.

3

Hi john

Thanks for the reply.

Actually I don’t want to give the user the ‘Execute any procedure’ permission. whenever i give the user the access to execute, everything is fine, but we have a security problem not to give told permission.( I know it seems odd but this is someone else’s to decide)

GRANT SELECT ON DBA_SOURCE didn’t work for me.

Regards

4

I didn’t mean “execute any procedure”, I just meant “grant execute on procedure_name to user_name”