Blog

• The Unexpected Security Implications for Role Owners

  

  2014-03-03 - General, Security, Security Pitfalls

  In SQL Server a server or database role can have an owner specified. Are you aware of the security implications of specifying a role owner? Read on to find out now.

  [more…]

• Schema Owner vs. Object Owner – Who wins?

  

  2014-03-02 - General, Security

  A table might have a different owner than the schema it is contained in. Does a permission granted on the schema still apply to the table in that case? Read on to find out now.

  [more…]

• The Mysterious Schema Owner

  

  2014-03-01 - General, Security

  Have you ever noticed a principal_id of NULL in one of the catalog views, indicating that no owner is set for that securable? Discover how this might impact your security management and what the schema owner has to do with it.

  [more…]

• ALTER AUTHORIZATION – Setting the Owner of a Securable

  

  2014-02-28 - General, Security

  ALTER AUTHORIZATION can be used to set the owner of a securable. Securable ownership is independent of the three security hierarchies. Read on to get all the details on how securable ownership might impact your security management.

  [more…]

• How to find all Implied Permissions using sys.fn_builtin_permissions

  

  2014-02-27 - General, Queries, Security

  Are you looking to get the complete list of implied permissions for a given permission? Read on to discover a query returning just that list, based on a recursive CTE against the sys.fn_builtin_permissions catalog function.

  [more…]

• Data Pages and the Row Offset Array

  

  2014-02-26 - General, Series, SQL Server Internals, Storage Wednesday

  SQL Server stores actual table data in pages of type 1, data pages. Read on to see how to navigate a data page and how to find each row using the row offset array.

  [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…]

• 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…]