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.
SoftwareOracle Database

Avatar of undefined
Last Comment
Sean Stuber

8/22/2022 - Mon
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
ASKER
mmoore

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

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER
mmoore

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.
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23
Sean Stuber

did you enable the role or just assign it?

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