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

Table column encryption Expand / Collapse
Author
Message
Posted Wednesday, January 29, 2014 1:22 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, January 29, 2014 1:39 AM
Points: 4, Visits: 28
Please how do i encrypt/decrypt column in a table so that the records will be useless for who ever wants to have access to it.

thanks
Post #1535751
Posted Thursday, January 30, 2014 9:23 AM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, April 04, 2014 10:54 AM
Points: 33, Visits: 233
This is quite a good starting point, although BOL does have some decent guides on this subject.

[url=http://blogs.technet.com/b/keithcombs/archive/2005/11/24/sql-server-2005-data-encryption.aspx][/url]
Post #1536414
Posted Monday, March 03, 2014 1:46 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 9:15 AM
Points: 1,192, Visits: 2,172
gabbyndu (1/29/2014)
Please how do i encrypt/decrypt column in a table so that the records will be useless for who ever wants to have access to it.

thanks


Check this ..

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

http://www.mssqltips.com/sqlservertip/2431/sql-server-column-level-encryption-example-using-symmetric-keys/

--
SQLBuddy
Post #1547082
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse