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