ALTER USER

Updates the configuration of the specified user.

For more information, see Managing users.

ALTER USER SET

Syntax

ALTER USER <user_name> SET
	[ LOGIN = <login_name> | DEFAULT ]
        [ SERVICE_ACCOUNT = <service_account_name> | DEFAULT ]
        [ DEFAULT_DATABASE = <database_name> | DEFAULT ]
	[ DEFAULT_ENGINE = <engine_name> | DEFAULT ];

or

ALTER USER <user_name> RENAME TO <new_user_name>;

Parameters

Parameter Description
<user_name> The name of the user. If the user name contains spaces or non-alphanumeric characters, it must be enclosed in single or double quotes.
<new_user_name> The new name of the user, used with the RENAME TO option. The new user name can be any string, and can also contain spaces and non-alpha-numeric characters such as exclamation points (!), percent signs (%), at signs(@), dot signs (.), underscore signs (_), minus signs (-), and asterisks (*). If the string contains spaces or non-alphanumeric characters, it must be enclosed in single or double quotes.
<login_name> An optional, case-insensitive parameter to specify the name of the login to link the user with, used with the SET option. This cannot be used in conjunction with the SERVICE_ACCOUNT parameter - a user can be linked to a login OR a service account but not both.
<service_account_name> An optional parameter to specify the name of the service account to link the user with, used with the SET option. This cannot be used in conjunction with the LOGIN parameter - a user can be linked to a login OR a service account but not both.
<database_name> An optional parameter to define a default database for the user (for future purposes). Used with the SET option.
<engine_name> An optional parameter to define a default engine for the user (for future purposes).Used with the SET option.

Example

The following command will rename the “alex” account to “alexs”.

ALTER USER "alex" RENAME TO "alexs";

This command will link the user “alex” to the “alexs@acme.com” login.

ALTER USER alex SET LOGIN="alexs@acme.com";

ALTER USER OWNER TO

Change the owner of a user. The current owner of a user can be viewed in the information_schema.users view on user_owner column.

Check ownership page for more info.

Syntax

ALTER USER <user_name> OWNER TO <user>

Parameters

Parameter Description
<user_name> The name of the user to change the owner of.
<user> The new owner of the user.