Browse by Tags

SQL Server 2005: Deny Server-Level Dynamic Management Views to public group

Published 21 December 7 7:47 AM | SSQA.net

As you are aware DMV - Dynamic management views are very good to provide server-level information and some of them with detailed information on the execution environment of the database engine. Just to introduce about DMVs, there are two types of dynamic...

Filed under: sql server, package, performance, security, dmv, users, view, best practice, public, monitoring, server state

Find VIEW ANY Database permission privileges for all users

Published 18 July 7 10:11 AM | SSQA.net

You may be aware that any login that is created on SQL Server will have permission or privilege to see all databases on that instance. This is due to VIEW ANY DATABASE permission that regulates the exposure of metadata system databases. This permission...

Filed under: sql server, databases, view, tsql, public