Post reply

Problem with delete a user

  • November 10, 2014 at 8:21 am

    #291798

    People,

    I am using SQL Server 2008 Express.

    I want do delete a user from a database, but when I try,I get this error Message:

    "The database principal owns a schema in the database, and cannot be dropped (MSSQL, Error:15138)"

    How can I delete this user?

  • November 10, 2014 at 8:28 am

    #1757442

    Transfer the schema ownership to another user first:

    ALTER AUTHORIZATION ON SCHEMA::someSchema TO anotherUser;

    -- Gianluca Sartori

  • August 17, 2015 at 7:12 am

    #1820420

    Hi. i´m new on sql, and i have this problem, my user to delete is Irma, she has dbo.owner and db.owner schemas, and i want to know what is the correct sintax.

    I gues: Alter authorizatios schema dbo.owner to sa

    Is this correct?

    Pleas help me with the correct sintax.

    Thanks a lot and best regards.

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

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