Tag: owner

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