Why can so many people view the procedure code? Although it is not unbreakable, how about wrapping the procedure to make things a bit more difficult.

Ian MacGregor
Stanford Linear Accelerator Center
[Email Address Removed] <mailto:[Email Address Removed]

-----Original Message-----
From: Shivsagar [mailto:[Email Address Removed]
Sent: Friday, May 30, 2003 11:48 AM
To: LazyDBA.com Discussion
Subject: dbms_obfuscation


Hi,
I need to encrypt and decrypt the column values of a particular table.
I am aware of DBMS_OBFUSCATION_TOOLKIT.DESENCRYPT and DBMS_OBFUSCATION_TOOLKIT.DESDECRYPT procedures.
Now both of these procedures need a key_string which is like a key to open the lock.
My problem is, if i write a stored proc to carry out this encryption/decryption, wouldnt the KEY be visible to anyone who can view the proc.
How do i make sure that no one except me and the boss knows the key.
Sagar

Oracle LazyDBA home page