Restricting access to Source of procedures

From: Allan Morris <allan.morris_at_actfs.com.au>
Date: 2000/05/31
Message-ID: <3934984F.3BD6F7D8_at_actfs.com.au>#1/1

[Quoted] I am running 7.1.6 of the database.

[Quoted] 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 Received on Wed May 31 2000 - 00:00:00 CEST

This message: [ Message body ]
Next message: Sybrand Bakker: "Re: Restricting access to Source of procedures"
Previous message: Mike Dwyer: "Re: item - navigation..."
Next in thread: Sybrand Bakker: "Re: Restricting access to Source of procedures"
Reply: Sybrand Bakker: "Re: Restricting access to Source of procedures"
Reply: Bonyata: "Re: Restricting access to Source of procedures"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message