locked
Cannot alter the user dbo. RRS feed

  • Question

  • Hi there,
    I receive this error 'Cannot alter the user dbo' when wishing to change acces for a specific SQL Login. I can find lots of hits when Googling for this error, but it always tells to change the ownership of the database and then change user&schema. However, this specific user is NOT the owner of the database, and I still get this error. This SQL Login 'USER' is an application-specific user with SA-rights, so it does not need explicit user-mappings, but they are there and I would wish to clean them up. I can remove the complete database from user-mappings but do not wish to take this step immediately without testing. This specific login also has a schema with the same name, so deleting this user from the database does not work either.

    Are there other issues here, of which I am not aware? Any hint/link to more info on this would be appreciated.
    Greetz, FreeHansje
    Thursday, December 24, 2009 9:58 AM

Answers

  • > This SQL Login 'USER' is an application-specific user with SA-rights....

    I'm guessing that ("with SA-rights") means that this login is a member of
    the sysadmin server role. That would make it dbo in every database. If you
    wish this not to be the case, you need to remove the login from sysadmin.

    Hope this helps,
    Bob Beauchemin
    SQLskills

    Thursday, December 24, 2009 6:56 PM

All replies

  • Hi,

    What action are you trying to perform here actually ?
    Are you trying to change some objects ownership or schema changes ?
    Thanks, Leks
    Thursday, December 24, 2009 6:08 PM
  • > This SQL Login 'USER' is an application-specific user with SA-rights....

    I'm guessing that ("with SA-rights") means that this login is a member of
    the sysadmin server role. That would make it dbo in every database. If you
    wish this not to be the case, you need to remove the login from sysadmin.

    Hope this helps,
    Bob Beauchemin
    SQLskills

    Thursday, December 24, 2009 6:56 PM