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 |
|
masterdineen
Aged Yak Warrior
550 Posts |
 Posted - 2009-10-06 : 10:21:58
|
| Hello.How do i deny or revoke a user from selecting from a whole database.sorry its really easy for you guysRegardsRobMCTS certified |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2009-10-06 : 10:35:59
|
| Either go into Security on Management Studio and untick their access from the user mappings tab under their username or use the REVOKE statement in T-SQL (Look it up in BOL). |
 |
|
|
|
|
|
revoke access problem