Post reply

dbo account issue

  • 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

  • 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

  • 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.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply