Tag: CV

• sys.sql_logins – Getting to know your SQL Logins

  

  2014-04-06 - DMVs & CVs, General, Security, Security

  The sys.sql_logins catalog view can be used to retrieve additional information on SQL Logins that is not included in the sys.server_principals catalog view. Read on to find out what additional information is revealed by this catalog view.

  [more…]

• The Allocation Unit

  

  2014-03-26 - DMVs & CVs, General, Series, SQL Server Internals, Storage Wednesday

  SQL Server groups all pages that belong to a single partition of a single index or heap into logical units. These units are called allocation units. Read on to learn about the different types of allocation units and discover how to identify the allocation units belonging to a table.

  [more…]

• What are my own effective permissions? Get Answers with sys.fn_my_permissions.

  

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

  Are you looking to identify your effective permissions in SQL Server, the permissions actually in effect after taking things like denies or role membership into account? Read on to see how sys.fn_my_permissions can help.

  [more…]

• Identify All Possible Permissions using sys.fn_builtin_permission

  

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

  The sys.fn_builtin_permissions catalog function returns a result set that contains one row for each possible permission that you can grant (or deny) in SQL Server. Read on to find out how to use it and how to interpret the results.

  [more…]

• How to identify active server permissions using sys.server_permissions

  

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

  The sys.server_permissions catalog view can be used to identify active server permissions, permissions with server scope that have been granted or denied to a server principal. Read on to find out how to interpret the output of this catalog view.

  [more…]