0

I have a database with many users who have access to all tables within the DB. There is one table that I would like to restrict access to only a specific few users. So basically granting table access to some while removing table access to the rest. Any thoughts on best way to accomplish this?

Martijn Pieters
  • 1,048,767
  • 296
  • 4,058
  • 3,343
Jenn
  • 35
  • 1
  • 9

1 Answers1

0

You could always DENY SELECT to all users on that table, and then grant it by person for the few you do want to have access to it.

DENY Object Permissions (Transact-SQL)

This question may also help you: SQL Server : can you limit access to only one table

Community
  • 1
  • 1
pinmonkeyiii
  • 191
  • 1
  • 3