Just have them check the code out of your Source Code Control system.
On 10/1/07, Sam Bootsma <sbootsma_at_georgebrown.ca> wrote:
>
> We would like our developers to see source code for all objects in
> selected schemas in our production database. I believe I have read that
> granting execute privilege on a stored procedure will also make that stored
> procedure visible in the all_source view, but we do not want to give our
> developers execute privileges in the production environment.
>
>
>
> Is there a way to enable developers to view all source code for selected
> schemas without providing additional privileges? I'd like to avoid giving
> dba_source privileges.
>
>
>
> Thanks!
>
>
>
> *Sam Bootsma*
>
> *Oracle Database Administrator*
>
> *Information** Technology Services**
> George Brown College*
>
> *Phone: 416-415-5000 x4933**
> Fax: 416-415-4836**
> E-mail: **sbootsma_at_georgebrown.ca* <sbootsma_at_georgebrown.ca>
>
>
>
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Oct 01 2007 - 17:38:02 CDT
