asked on 1/28/2009

Running DEBUG on objects not owned by logged in user

What I am trying to accomplish is to allow our QA people, in schema A, to run debugger on packages that reside in schema B.

so far I've done:

GRANT debug any procedure, debug connect session TO A;
Grant execute on B.my_proc to A;

While logged in a user A, Oracle Developer, has the problem:
won't load the BODY of my_proc into their built-in source code editor.
So, no way to set break points etc.
It's the same problem with TOAD

I am looking for any solution (developer, toad, whatever) that will allow USER A to debug packages where the owner is USER B.

Software Oracle Database

Last Comment

Sean Stuber

1/29/2009

Sean Stuber

1/29/2009

set our tools to use dba_xxxx views instead of all_xxxxx or user_xxxxx views.

you may need to grant select_catalog_role or select any dictionary to view the dba_xxxxx views

mmoore

1/29/2009

ASKER

Ok, you've lost me a little bit. I'm not sure what you mean by "our tools", I assume you mean "your tools". I am working with Oracle Developer. Can you tell me how to set Developer to use the dba views, or should I get that information from OTN?
thanks,
Mike

ASKER CERTIFIED SOLUTION

Sean Stuber

1/29/2009

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

mmoore

1/29/2009

ASKER

I first tried Grant SELECT_CATALOG_ROLE and it still did not work. Then I added "grant select any dictionary" and it worked. Not sure at this point if the select_catalog_role was actually needed.

Sean Stuber

1/29/2009

did you enable the role or just assign it?

you don't really need it if you have select any dictionary