RE: custom DD views to allow users to see source without needing

2002-06-06 Thread Jared . Still
t; <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 06/05/2002 01:03 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: RE: custom DD views to allow users to see source without needing We have the

RE: custom DD views to allow users to see source without needing

2002-06-05 Thread Jamadagni, Rajendra
We have granted view on dba_source, dba_arguments and dba_objects to developers. As for debugging, we create a copy of production db as of 5AM and make it available to developers (after scrambling some data). It is their playground to fix and diagnose the problems. In few days their complete acce

RE: custom DD views to allow users to see source without needing

2002-06-05 Thread Miller, Jay
We have the same problem with SQL Navigator. Any suggestions would be great. Jay Miller -Original Message- Sent: Tuesday, June 04, 2002 7:08 PM To: Multiple recipients of list ORACLE-L needing exe rights Hi, Jack & list, We had the same problem here and we finally resolved it in a si

Re: custom DD views to allow users to see source without needing exe rights

2002-06-04 Thread Mario J Gonzalez
Hi, Jack & list, We had the same problem here and we finally resolved it in a similar way. We created 3 views as sys : all_objects_xx, all_arguments_xx and all_source_xx, synonyms for both views and granted select permissions to user. But, we still have a problem. User needs to debug packages (s