dbo account issue

• Jimmpy Gill

  Say Hey Kid

  Points: 670

  More actions

  July 23, 2008 at 3:10 pm

  #191517

  normally dbo account is mapped to sa on user database. I've a user who's login mapped to dbo account. I'm unable to change the permission - I would like to map the user domain\abcuser account to db_datareader role and sa to be dbo - any suggetions? Thanks

• CDBA

  Hall of Fame

  Points: 3266

  More actions

  July 24, 2008 at 9:35 am

  #847881

  It is an wired situation I also faced. I suggest you to try using TSQL instead of GUI. It should work

  
  CDBA

• TRACEY-320982

  SSChampion

  Points: 13653

  More actions

  July 26, 2008 at 5:51 am

  #848766

  You can right click on database and change the owner of database to sa. Then just add the the other account as data reader.