I have a login I've created on SQL Server 2008, it's a SQL Server login not using AD. I want to give them access to every table in two databases except the tables that I store login information in for sites and such. This is one table in each database. Ideally, I'd like them to automatically get access to any new tables added to either database without breaking that restriction on those two login info tables.
Sql-server – SQL – Best way to limit access to small number of tables
sql serversql-server-2008
Related Question
- SQL Server – Allow Update Access to Only 2 Tables in a Database Schema
- SQL Server 2008 R2 – Grant Role in One Database Access to Tables in Another Database
- SQL Server Login – Access Tables Across Multiple Databases
- SQL Server – How Access Tables Are Linked with SQL Server
- Sql-server – SQL Server 2008 R2 – Access Failure in a query that uses Linked server
- SQL Server – Default Tables in Database
- Sql-server – Debugging table permissions for a windows user
Best Answer
Just place a DENY ALL on the table for that user. DENYs are always evaluated first, and will override the GRANT off SELECT to the overall schema:
There is no reason to move the login table into a separate schema.