Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: View Any Procedure
celvart_at_hotmail.com schreef:
> 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?
>
grant select on dba_source, or on sys.source$?
-- Regards, Frank van Bortel Top-posting is one way to shut me up...Received on Thu Feb 08 2007 - 12:32:20 CST