SQL Server Performance

subtle difference in accounts that are the database onwer or is just a memeber of the db_owner role

Discussion in 'ALL SQL SERVER QUESTIONS' started by Trev256b, Jul 18, 2013.

  1. Trev256b Member

    I have noticed that an account that is actually the database owner differs from another account which is a member of the db_owner role. Both accounts should have db_owner role access and they are both listed under the db_owner role in the database (i.e. 'dbo' and 'user account' are listed). However when the application is changed and the database owner account is replaced by the account which is a member of the db_owner database role user connection is not possible.
    1) Does anyone know why this happens?
    2) Could it be linked to the fact database objects when created by the account with db_owner role access actually are 'owned' by the user account (i.e. accountname.tablename)?

Share This Page