Home » SQL & PL/SQL » SQL & PL/SQL » Hiding Package
Hiding Package [message #190086] Tue, 29 August 2006 04:30 Go to next message
Messages: 29
Registered: August 2006
Location: Bangalore
Junior Member

Can I hide source code of package,procedure and function
in sql * plus

Re: Hiding Package [message #190096 is a reply to message #190086] Tue, 29 August 2006 04:53 Go to previous message
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
You can wrap the code.
Be aware that this process is irreversible on the server, so make sure you have copies of the code.

You can also move your code into a different schema which has all the required privs to access the tables, and grant execute on the code to the users. This will prevent anyone without access to DBA_SOURCE or CREATE ANY PROCEDURE from seeing the package body.
Previous Topic: Drop column query
Next Topic: DECODE function
Goto Forum:

Current Time: Mon Oct 24 16:02:51 CDT 2016

Total time taken to generate the page: 0.14035 seconds