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 |
|
Bonzol
Starting Member
3 Posts |
 Posted - 2007-10-02 : 06:48:02
|
| Hello!I'm having trouble doing a basic permission, I need to prevent one user from seeing one column in a view, such as a students phone number. However, when I deny the user from seeing the column it denys the user from viewing the entire view. Can someone tell me the correct way to deny the user from just the one column. Thanks in advanceChris |
|
|
Zoroaster
Aged Yak Warrior
702 Posts |
Posted - 2007-10-02 : 07:50:50
|
I don't think it can be done, why not create a different view for that user?
Future guru in the making. |
 |
|
|
crosan
Starting Member
13 Posts |
Posted - 2007-10-02 : 11:55:23
|
| What statement are they using to access the view? Is it possible to include only the columns they need (and have permission to see) to see in the query? |
|
|
|
|
|
|
Basic SQL server 2005 Permission question