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. |