Home Forums SQL Server 2005 SQL Server 2005 Security Reassigning the ownership of db_owner RE: Reassigning the ownership of db_owner

  • June 24, 2009 at 10:20 am

    #1014768

    The default owner of the db_owner Schema is dbo. Use this to change it back.

    USE [DatabaseName]

    GO

    ALTER AUTHORIZATION ON SCHEMA::[db_owner] TO [dbo]

    GO