Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: View Any Procedure

Re: View Any Procedure

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Thu, 08 Feb 2007 19:32:20 +0100
Message-ID: <eqfqaf$bvv$1@news5.zwoll1.ov.home.nl>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US