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 |
|
rajesha
Starting Member
36 Posts |
 Posted - 2002-05-21 : 23:30:17
|
| how to encrypt data in table coloumns in sql7 or sql2000.so that only users having permissions can see(or discrypt )the data in the coloumn the permission is given by depending on their name(let's suppose)on the same table in another coloumn. here i dont want to encrypt all the coloumns in the table. see this tablename password jobabi 2w3kjh enggwill uke68k doctjim jkf98kj teacherin this table i want to encrypt only the password coloumn .so that only junk character will come there.and this data can be seen to the responsible person (if he is checking table through enterprise manager) for eg.abci can see his password in enterprise manager but not others password..is there any facility for that. |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2002-05-21 : 23:55:07
|
| Short answer .. no.Long answer, definitely not in Enterprise manager. But you could encrypt all your data and build an interface in VB or ASP that will decrypt relevant data.But it will be slow, and basically more trouble than it is worth.I think you should just put proper permissions on the tables so people can not see them in enterprise manager unless they are supposed to.Damian |
 |
|
|
|
|
|
how to encrypt data in table"s coloumn