Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Restricting access to Source of procedures
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
Received on Wed May 31 2000 - 00:00:00 CDT