SQL Server Performance

sp_changedbowner permissions

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

  1. Trev256b Member

    I have added a SQL login as the database owner via sp_changedbowner 'NewLogin', so the propoerties of the database show: Owner = 'NewLogin' - but this does not give it dbo rights.

    1) Is this correct?
    2) Do you have to grant it specific 'dbo' rights so it is displayed as a user in the database?

Share This Page