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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-10-09 : 08:00:59
|
| Pradeep writes "I have a table with login name and password columns in it. Isnt there a way to modify the table so that the password column shows asterisks instead of clear text?Is there a way to hide the password column from viewing in the table data and at the same time i should be able to access the data the password column using select query" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-10-09 : 08:03:18
|
quote:
Isnt there a way to modify the table so that the password column shows asterisks instead of clear text?
Sure, you just need to write your own front-end application. DO NOT USE ENTERPRISE MANAGER for your general data browsing, and DO NOT ALLOW END USERS to use Enterprise Manager at all.If you truly need to secure this column, the best thing to do is to deny SELECT permission to the table, then create views on it. One view with the password for your use, one without the password for use by general users. Make sure to deny SELECT permissions on the first view to all users besides yourself. |
 |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2003-10-09 : 20:18:09
|
| Or you could always look into data encryption. But be careful, there are a lot of down-sides to it as well as benefits.--------------------------------------------------------Visit the SQLTeam Weblogs at [url]http://weblogs.sqlteam.com[/url] |
|
|
|
|
|
|
permission for table columns