Discussion Locked

SQL Server Column Encryption

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi all,
Is there anyway i can encrypt a column in SQL server 7.0? I have a volumn that contains passsowrds that i dont want administrators to see at the back-end. thanks...

1 reply

by shelleydoll

Most secure option all round is to encrypt the field in software before it gets anywhere near a database or log file - should be encrypted as soon as the server gets the info from the user. Otherwise this implies the password is sitting in a session, cookie, or temporary file somewhere in plaintext, waiting to get stored.

This discussion is closed to new replies.