Re: How to keep Stored Procedure "a Secret"???

Carl Tichler wrote:
>
> For what its worth, Oracle has introduced a way to save and load
> a stored procedure in an encrypted format, as of version 7.1 or 7.2.
>
> Carl Tichler
> catech_at_cloud9.net
>
> "hector.tello" <htello_at_onr.com> wrote:
> >I am looking into migrating an old x-base application to a PowerBuilder with
> >Sybase/Oracle/MS SQL Server platform. A lot of improvement is expected from moving
> >the heavy data manipulation procedures to the server as stored procedures. However,
> >there are a couple of procedures which are proprietary. Not even the customer's DBA
> >should be able to see these procedures. Not giving DBA access to the customer is not
> >an option because this database will be integrated within the customer's larger
> >information systems.
> >
> >Any suggestions??? Is there something I can do on the server side? What about the
> >client (PowerBuilder) side?
> >
> >Thanks in advance. Mail to htello_at_onr.com.
> >The encrypted format is called a wrapper. Look in the PL/SQL manual and
you can see how to wrap your proprietary algorithms.

Tim

-- 
+-----------------------------------------------------------------------+ 
|Timothy E. Taylor				Oracle Government       
| 
|Staff Sales Consultant				3 Bethesda Metro Center 
| 
|Internet:	ttaylor_at_us.oracle.com		Suite 1400              
| 
|Office:	301-907-2395			Bethesda, MD 20814      
| 
|Fax:		301-657-0037                                            
| 
 +-----------------------------------------------------------------------+ 
| 	They teach you to fix what needs to be broke (P.W., 1993)	
| 
+-----------------------------------------------------------------------+