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 |
|
Glockenspiel
Yak Posting Veteran
50 Posts |
 Posted - 2004-04-19 : 17:44:06
|
| Hoping this is an easy one for you gurus...I added a user account to the special role 'db_datareader'. Next, I REVOKed SELECT access from one column of a table using the following:REVOKE SELECT (ColumnName) ON TableName FROM AccountNameWhy can the user account still see the column?And... how can I achieve the desired results of having the account be able to see everything except the one column of this one table.Thanks!!!! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-04-19 : 17:49:11
|
| DENY SELECT (ColumnName) ON TableName TO AccountNameTara |
 |
|
|
Glockenspiel
Yak Posting Veteran
50 Posts |
Posted - 2004-04-20 : 08:56:19
|
Doh!  Many thanks! |
|
|
|
|
|
|
REVOKE and special roles