Tag: owner

• The Ownership Chain – How the Securable Owner affects Permission Enforcement in SQL Server

  

  2014-03-14 - General, Security

  The ownership chain enables us to setup guarded access in SQL Server. Guarded access means to grant securable access only through a procedure or view. That module can then be used to enforce additional security requirements. Read on to see how the ownership chain makes this possible.

  [more…]

• An implicit user creation has failed.

  

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

  The error message “An implicit user creation has failed.” indicates that SQL Server tried to create a user automatically and failed. Read on to see when and why this happens.

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