login mapped to user dbo

• bdh-550389

  Old Hand

  Points: 380

  More actions

  October 27, 2008 at 3:37 am

  #131802

  Hi

  I have a problem with rights after restoring a database from a backup. The backup have removed all the rights in the database. I have then removed all users in the database and mapped the login to the new users and assign their rights.

  I have one login that has been mapped to the dbo user in the database and I cannot alter the dbo user to not have a login and if I delete the login and create it again the I get an error saying that a user already exits.

  Does anybody know how to solve this problem?

  Kind regards

  Bo

• bdh-550389

  Old Hand

  Points: 380

  More actions

  October 27, 2008 at 3:56 am

  #889886

  I found a way

  Change the dbo users login to SA with this command

  exec sp_changedbowner 'sa', true

  and then mapped the login to a new user in the database.

  Regards

  Bo

• Atif

  Hall of Fame

  Points: 3578

  More actions

  October 27, 2008 at 5:09 am

  #889901

  sp_change_users_login @Action='update_one',

  @UserNamePattern='username',

  @LoginName='dbo'

  GO

  provide name of your user in 'username' and then try to map the user by running above command.

  DBDigger Microsoft Data Platform Consultancy.