General information
Forum:
Microsoft SQL Server
Title:
Deny User's Access to Multiple Tables
Environment versions
SQL Server:
SQL Server 2000
I have two databases with 300 tables each. I need to deny a user's right to select, insert, delete, and update on all of the tables in both databases except for 5 tables in each of the databases. I can manuualy run the "DENY" command for each table in each database but that would be very labor intensive. How do I run a single command denying the user's access to all of the tables except for the five I need the user to have select rights?
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only