|
[oracle-l]
||
[Date Prev]
[10-2007 Date Index]
[Date Next]
||
[Thread Prev]
[10-2007 Thread Index]
[Thread Next]
Re: All_Source Question
- From: "sol beach" <sol.beach@xxxxxxxxx>
- To: sbootsma@xxxxxxxxxxxxxx
- Date: Mon, 1 Oct 2007 15:38:02 -0700
Just have them check the code out of your Source Code Control system.
On 10/1/07, Sam Bootsma <sbootsma@xxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxx* <sbootsma@xxxxxxxxxxxxxx>
>
>
>
|
