Re: how to give user privilege to browse the source code in prodution
From: Michel Cadot <micadot{at}altern{dot}org>
Date: Wed, 22 Sep 2010 22:46:39 +0200
Message-ID: <4c9a6b42$0$21381$426a74cc_at_news.free.fr>
Date: Wed, 22 Sep 2010 22:46:39 +0200
Message-ID: <4c9a6b42$0$21381$426a74cc_at_news.free.fr>
"charles" <dshproperty_at_gmail.com> a écrit dans le message de news:
880b62ca-c4c1-4d7e-9d16-b87d391a4b7a_at_j5g2000vbg.googlegroups.com...
| All,
|
| We are at Oracle 10g. We need to let our developer to browse source
| code like packages/functions/triggers.
|
| The only way i can think of is grant select any dictionary. Is there
| any security risk there by doing that? What is other options?
|
| Thanks for your help
Create a procedure in procedure/... owner schema that displays the code source and grant developers the privilege to execute this procedure.
Regards
Michel
Received on Wed Sep 22 2010 - 15:46:39 CDT