|
[oracle-l]
||
[Date Prev]
[10-2007 Date Index]
[Date Next]
||
[Thread Prev]
[10-2007 Thread Index]
[Thread Next]
All_Source Question
- From: "Sam Bootsma" <sbootsma@xxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 1 Oct 2007 17:19:41 -0400
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 <mailto:sbootsma@xxxxxxxxxxxxxx>
|
