Re: Restricting access to Source of procedures

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 2000/05/31
Message-ID: <959749336.12454.0.pluto.d4ee154e@news.demon.nl>#1/1

Allan Morris <allan.morris_at_actfs.com.au> schreef in berichtnieuws 3934984F.3BD6F7D8_at_actfs.com.au...
> I am running 7.1.6 of the database.
>
> I am trying to restrict the users from viewing the source of objects ie
> the source of procedures/triggers when in Sqlplus, as I see it I have
> two options :
>
> 1/ Remove any public grants/synonyms on all the system objects. Or
> simply on the views all_source and all_triggers.
>
> 2/ Encrypt the procedures/triggers in the database. Can someone point me
> in the right direction on how to do this ?
>
> Which is the best way to go ?
>
> Thanks
> Allan
>
>

1 will screw up more than your like
2 is possible with a special wrap utility in your bin directory

Hth,

Sybrand Bakker, Oracle DBA Received on Wed May 31 2000 - 00:00:00 CDT