Re: privilege to a DBA in Oracle

Code much of your application logic as stored packages/procedures. Then use Oracle's 'wrap' utility to encrypt the contents. This is precisely what Oracle does with some of their proprietary code. If you need to hide data, then you'll have to use the DBMS_OBFUSCATION_TOOLKIT to encrypt the data. In either case, the DBA can still see the stuff, but it just looks like junk.

HTH,
Brian

> Thanks for your response...Basically, the database is an intellectual
> property of mine and I wish not to provide read/write access to
> certain objects when my database is transferred to my client's server.
> Is there any legal way of providing partial access to my client's
> staff (including thier DBA).

-- 
===================================================================

Brian Peasland
oracle_dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"