Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Encrypt and Decrypt Expand / Collapse
Author
Message
Posted Thursday, January 02, 2014 11:05 PM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, April 11, 2014 3:18 AM
Points: 199, Visits: 499
Hi All,

I have an requirement that, i have to Encrypt Salary's Information in my database. Basically, it has Employee's Salary Break Up details like LTA, Basic, Special Pay....

So from the above one, i need to Encrypt all the Salary's Information and Decrypt the same when it required. I have seen some Built in Functionalists say EncryptByPassPhrase, EncryptByKey....

Can you please suggest me, Are there any other way where i can do this Encryption?

Thanks All....
Post #1527350
Posted Sunday, January 05, 2014 6:10 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, April 02, 2014 9:42 PM
Points: 57, Visits: 96
You are right, there are built in functions. I can't imagine why you would not use them, but the only sensible alternative is to use the Cryptography namespace in C#, and follow this:

http://technet.microsoft.com/en-us/library/ms345136(v=sql.90).aspx

to use CLR code inside SQL Server.
Post #1527947
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse