Category: DMVs & CVs

• How to identify active database permissions using sys.database_permissions

  

  2014-02-22 - DMVs & CVs, General, Security, Security

  The sys.database_permissions catalog view can be used to identify active database permissions that are defined in the current database. Read on to find out how to interpret the output of this catalog view.

  [more…]

• SQL Server Database Users and the sys.database_principals catalog view

  

  2014-01-03 - DMVs & CVs, General, Security, Security

  Database principals like the database user allow use to grant permissions on objects in a given database. Check out how to list users and find their linked logins.

  [more…]

• SQL Server Logins and the sys.server_principals catalog view

  

  2014-01-02 - DMVs & CVs, Fundamentals, General, Security, Security

  SQL Server knows two types of security principals: The login or server principal and the database user or database principal. Read on to learn more about the server principal.

  [more…]