Thanks Thomas, I'll let you know how it goes. Mike On Thu, Nov 6, 2008 at 2:02 PM, Thomas Olszewicki <[EMAIL PROTECTED]> wrote:
> > On Nov 6, 1:19 pm, "Michael Moore" <[EMAIL PROTECTED]> wrote: > > This is my second attempt to send this. It does not seem to be getting > > posted to the group. > > > > On Wed, Nov 5, 2008 at 9:49 AM, Michael Moore <[EMAIL PROTECTED] > >wrote: > > > > > > > > > Hello, > > > > > We have packages in schema DEV_APP our QA have individual schemas. For > > > example, my schema would be MMOORE. > > > > > I would like our QA's to be able to run debugger (Oracle SQL Developer > > > debugger) on those packages in DEV_APP. > > > > > What GRANTS, privs, etc would I need to give MMOORE so that he can > debug > > > packages in DEV_APP? > > > > > So far I have done: > > > > > *GRANT debug any procedure, debug connect session TO mmoore;* > > > > > *Grant execute on dev_app.calc_daily to mmoore; > > > > > * > > > > > When logged in as MMOORE, I can not even see DEV_APP.CALC_DAILY using > > > DEVELOPER and drill down under "Other Users". > > > > > None of what I have mentioned is cross-instance ... it's all on the > same > > > SID. > > > > > TIA for your help. > > > > > Mike- Hide quoted text - > > > > - Show quoted text - > > Mike, > In theory if you grant execute of DEV_APP.CALC_DAILY to MMOORE, user > MMOORE should be able > to query ALL_SOURCE for the source of function/procedure/package > DEV_APP.CALC_DAILY. > Now the question is what SQL Developer uses to show source code? > It could be DBA_SOURCE or dbms_metadata package or ALL_SOURCE. > I don't use SQL Developer so cannot answer that question. > > In my case (PL/SQL Developer from Allround Automations) I had to > enable DBA_... views > for users in order to view other user's source. > > For debugging : user MMOORE must be also granted "create any > procedure" in order to > debug another user's package bodies. > > HTH > Thomas > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en -~----------~----~----~----~------~----~------~--~---
