Re: Encrypting the contents of a column

I'm not sure I fully understand the question ( who's looking over the DBA's shoulder - ask them to leave...) - however a on-insert trigger should be able to apply some encryption scheme using , for instance, a string substitution routine ( you know, like we did as kids, a=d b=f,c=y etc.. ) loop thru the input string, make the substitution, save the new string... ( if the input is a number, try raising it to some pre-selected power )...

for output, the unwatched DBA can reverse the process....

[ Note, this is a 'off the top of my head' ( where hair used to be ) solution and others, especially Tom Kyte, will probably provide a more sophisticated solution ]  

jmeiri_at_netdialog.com wrote:

>Hi all, I’m looking for a way (an easy way), to encrypt to contents of a
>column within an application table. The idea is that no one overlooking the
>DBA’s shoulder will see what the column contains. The DBA will be the only
>able to run the PL/SQL code for encryption/decryption. Thanks… Josh <<
>Encrypting the contents of a column >>
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own

To reply please remove the 'nospam' part of the address Received on Tue Feb 02 1999 - 15:17:29 CST