Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: View Any Procedure
celvart_at_hotmail.com wrote:
> We have a new corporate security mandate that does not allow us to
> grant ALTER ANY PROCEDURE to our developers.
>
> I agree that this should be a function of the DBA, but I have a
> problem in that the developers need to be able to look at the source
> code in order to diagnose problems.
>
> Is there any way to let the developers view source code without being
> able to modify it?
>
dbms_metadata.get_ddl
documented at http://tahiti.oracle.com
demos at www.psoug.org in Morgan's Library
No one should be using ALTER to extract source code. Going back into the Neolithic period it would still have been preferable to to go to user_source or source$.
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Thu Feb 08 2007 - 12:30:05 CST