If you just need to make the source code unreadable, then you should use
WRAP.
Take a procedure and save it into a .sql file (example: myproc.sql)
Then use the wrap utility:
wrap iname=myproc.sql
This creates a .plb file (myproc.plb) which you can load into your database
as if it were a sql file, but is totally unreadable.
Do this for all your procs, etc.
NOTE: Do NOT lose your source code or you are screwed!!
HTH
John.
-----Original Message-----
From: Rajeev Sharma
[mailto:oracledba-ezmlmshield-x41389150.[Email address protected]
Sent: 31 July 2007 07:22
To: LazyDBA Discussion
Subject: Hide Code
Hi Guru's,
I have to Hide the PL/SQL code as (Procedure,
Function, Triggers) from the users which are working with same Schema.
Please Tell Me How to implement this. Please don't revert With Wrap Key
Word.
With Best Regards
Rajeev Sharma
(~_~)
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
-----------------------------------------
Information in this email including any attachments may be
privileged, confidential and is intended exclusively for the
addressee. The views expressed may not be official policy, but the
personal views of the originator. If you have received it in error,
please notify the sender by return e-mail and delete it from your
system. You should not reproduce, distribute, store, retransmit,
use or disclose its contents to anyone.
Please note we reserve the right to monitor all e-mail
communication through our internal and external networks.
SKY and the SKY marks are trade marks of British Sky Broadcasting
Group plc and are used under licence. British Sky Broadcasting
Limited (Registration No. 2906991), Sky Interactive Limited
(Registration No. 3554332), Sky-In-Home Service Limited
(Registration No. 2067075) and Sky Subscribers Services Limited
(Registration No. 2340150) are direct or indirect subsidiaries of
British Sky Broadcasting Group plc (Registration No. 2247735). All
of the companies mentioned in this paragraph are incorporated in
England and Wales and share the same registered office at Grant
Way, Isleworth, Middlesex TW7 5QD.
Oracle LazyDBA home page