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 |
|
inbs
Aged Yak Warrior
860 Posts |
 Posted - 2009-03-30 : 09:24:26
|
| i writegrant select on [OrderTable] to [username]but the user still the all tables in the DataBase, and i want he can work just with OrderTablehow can i do it? |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-03-30 : 22:31:43
|
| See if that user has been assigned to fixed database role. |
 |
|
|
|
|
|
permission to user