Post reply

'Cannot alter the user dbo'

  • December 24, 2009 at 2:43 am

    #136961

    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,
    Hans Brouwer

  • December 24, 2009 at 3:17 am

    #1096273

    FreeHansje (12/24/2009)

    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.

    Hope this link ll help u

    http://social.msdn.microsoft.com/Forums/en/sqlsecurity/thread/113b2935-7523-4581-ace0-1c145ea4a5d8%5B/url%5D

    http://social.msdn.microsoft.com/Forums/en/sqlsecurity/thread/113b2935-7523-4581-ace0-1c145ea4a5d8

    Edit:Post the correct link

    Muthukkumaran Kaliyamoorthy
    https://www.sqlserverblogforum.com/

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

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