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 |
|
Ravikumarc
Yak Posting Veteran
51 Posts |
 Posted - 2009-09-08 : 18:47:18
|
| Dear All,Im new bee to Sql DBA,can you pls let me knw "How to revoke all objects except one object for a user who has select permission"User named Dr has 150 tables,here i have to revoke 149 tables select permission except one table....Please advice on this issueThanks & RegardsRavi |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2009-09-08 : 19:09:26
|
| Please do not cross post:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=132472 |
 |
|
|
|
|
|
How to revoke all objects except one object