Start Sql server information schema not updating

Sql server information schema not updating

Consequently on 2008 R2 you need to explicitly DENY for each GRANT to [public].

Solution: The only way I could make the yeah, thanks.

Assume you have a SQL login for simplicity: Now you want to prevent this login from accessing any of the tables in the system-provided schemas - [sys] and [INFORMATION_SCHEMA].

It appears there was a behaviour change between SQL Server 2008 R2 and SQL Server 2012: In SQL Server 2012 (and presumably later versions), running the following in the [master] database does as you would expect: However, in SQL Server 2008 R2 (and presumably earlier versions), the stock grant statements giving access on objects in these schemas to members of [public] seem to override the above DENY statements, which seems like a huge pile of fail to me.

However, My SQL has omitted many columns that are not relevant for our implementation, and added columns that are My SQL-specific.