Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
cutever
Starting Member
32 Posts |
 Posted - 2002-04-04 : 02:42:31
|
| How do I encrypt the data using SQL Server.Example: User Table contains confidential data about the user such as: password, credit card no. credit card expired date…..and so on.I would like to encrypt the data, so that other staffs are not able to change or view that info.TQVer |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2002-04-04 : 02:49:32
|
| HiIf you do a forum search for encryption you will find some more info. But basically, the best way to do it is use a component like ASPEncrypt (use google to find it). There is an undocumented encryption function in SQL Server, but that won't unencrypt stuff so it is probably not much good to you.Also, look at implementing a good database object permission system on your database. Use stored procedures to access data and deny all other users direct access to your tables.Damian |
 |
|
|
cutever
Starting Member
32 Posts |
Posted - 2002-04-04 : 03:11:35
|
I do implementing a good database object permission system on my database and use stored procedures to access data and deny all other users direct access to my tables. However, I still affair that some staff will copy customer's information for their own business purpose.Does SQL SERVER provide any own encryption tool/function to encrypt the user data?What is SSL- Net-Library Encryption ? How to use ? Ver |
|
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2002-04-04 : 03:18:33
|
| I just told you that SQL Server will encrypt, but will NOT decrypt. So it is no good for you.You are best off buying a 3rd party encryption tool like ASP Encrypt.Net Library encryption is just encrypting SQL Server's netowrk traffic so that does not help you.Damian |
|
|
|
cutever
Starting Member
32 Posts |
Posted - 2002-04-04 : 03:31:20
|
It’s Cool!!!  Yes....This is what I want.I want encrypt the data and NOT decide to decrypt it later.  Could you please show me HOW???TQ....Ver |
|
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2002-04-04 : 08:14:25
|
| No, you really don't want that.If you encrypt someones credit card, you need to be abe to use it at some point.I'm going to say it again, use aspencrypt, or search the forums for some more discussion.Damian |
|
|
|
|
|
|
Encrypt the user data !!! [:)]