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 -~----------~----~----~----~------~----~------~--~---
