ALTER AUTHORIZATION (TSQL Statement)

changes the owner of the database.

Syntax

ALTER AUTHORIZATION
    ON DATABASE::database_name
    TO login_name

Arguments

database_name

name of the database

login_name

is the login name of the new owner of the database.

Remarks

Only sa or dbo is allowed to execute this statement.

By default, all new databases are owned by login sa.

The owner of a database is the login of the dbo user.

To remove the ownership of the database from a login, you must specify another login as new owner. It can be sa.

Examples

ALTER AUTHORIZATION ON DATABASE::clients TO alice;  -- new owner is login alice

ALTER AUTHORIZATION ON DATABASE::clients TO sa;     -- new owner is login sa