All_Source Question

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 <mailto:sbootsma_at_georgebrown.ca>  

--
http://www.freelists.org/webpage/oracle-l