Encripting seconds column in sql 2005

Question

Encripting seconds column in sql 2005

sadda

Newbie

Points: 6
More actions
December 29, 2008 at 10:47 am

#195532

right now we are storing seconds in a table. but i want to encrypt that seconds value

Viewing 6 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004514 More actions · Answer 1

May I ask why a column containing seconds would be confidential information needing encrypting? Who are you trying to protect that column against?

Look up the Encrypt functions that SQL 2005 has. EncryptByKey, EncryptByPassword (I think), there may be more.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

sadda Newbie Points: 6 More actions · Answer 2

Yes. That column needs to protect from client visibilty.

ps. One Orange Chip Points: 29423 More actions · Answer 3

Refer BOL. This link contains good example of enctyption using AES algorithm.

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/38e9bf58-10c6-46ed-83cb-e2d76cda0adc.htm

Pradeep Singh

ps. One Orange Chip Points: 29423 More actions · Answer 4

That link if from your Books Online.

Simple way to copy/paste that link in your Query Window in SSMS and do CTRL+CLICK. it'll take you to required page.

Pradeep Singh

Matt Miller (4) SSC Guru Points: 124210 More actions · Answer 5

The big problem is that you're leaving the question so very undefined, it's hard to answer it. Knowing what kind of encryption you need, figuring out whether the built-in encryption routines (along with their pitfalls) are good enough, or if it's better to use an external encryption (so that SQL Server can't understand it on its own), the encryption strength required for your business purpose, The business purpose itself of the field, etc... all would be useful.

Right now the best we can really do is point you at Books Online to do some reading and start thinking on it..... There's no one single "right answer" to this question.....

----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?