Tag: SQL Server

• Who is the Default Owner of your Database and Server Objects?

  

  2014-03-04 - General, Security

  When a new securable is created and an owner is not specified, a default owner is set. What server or database principal is used for the owner by default? 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…]

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