Guest_imported
New member
- Jan 1, 1970
- 0
how can i encrypt and decrypt a database field with ms sql server
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
encrypt a database field with MS sql server
- Thread starter Guest_imported
- Start date
- Status
rajeevnandanmishra
Programmer
Hi there,
I don't think if sql server automatically encrypt/decrypt the data in user tables.
You can maintain the security via
1.) LoginName/Password and giving proper access rights (Recommended because cost less overhead).
2.) By writing your own procedure for encrypt/decrypt and call it while retreiving/updating data value)
I don't think if sql server automatically encrypt/decrypt the data in user tables.
You can maintain the security via
1.) LoginName/Password and giving proper access rights (Recommended because cost less overhead).
2.) By writing your own procedure for encrypt/decrypt and call it while retreiving/updating data value)
- Status
Similar threads
- Locked
- Question
- Locked
- Question
