Tag: security

• CONTROL SERVER vs. sysadmin – Differences when Creating a Schema

  

  2014-03-07 - CONTROL SERVER vs. sysadmin, General, Security, Security Pitfalls

  The CONTROL SERVER privilege and a membership in sysadmin are supposed to be equivalent. However, there are substantial differences, e.g. securable ownership. Read on to see what happens when a schema is created by a login with CONTROL SERVER permissions.

  [more…]

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

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