Link to home
Start Free TrialLog in
Avatar of mmoore
mmooreFlag for United States of America

asked on

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.
Avatar of Sean Stuber
Sean Stuber

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
Avatar of mmoore

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
Avatar of Sean Stuber
Sean Stuber

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of mmoore

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.
did you enable the role or just assign it?

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