Updates the configuration of the specified account.

For more information, see Managing accounts.

​
ALTER ACCOUNT RENAME TO

Renames an account.

​
Syntax

ALTER ACCOUNT <account_name> RENAME TO <new_account_name>;

​
Parameters

ParameterDescription
<account_name>The name of the account to be altered.
<new_account_name>The new name for the account. The account name must start and end with an alphabetic character and cannot contain spaces or special characters except for hyphens (-).

​
Example

The following command will rename the “dev” account to “staging”.

ALTER ACCOUNT dev RENAME TO staging;

​
ALTER ACCOUNT OWNER TO

Changes the owner of an account.

You can view the current owner in the account_owner column of the information_schema.accounts view.

For more information, see ownership.

​
Syntax

ALTER ACCOUNT <account_name> OWNER TO <identity>

​
Parameters

ParameterDescription
<account_name>The name of the account to change the owner of.
<identity>The new owner of the account, which can be the name of a login or service account.

​
Example

The following command will set account “dev” owner to “alice@acme.com”.

ALTER ACCOUNT "dev" OWNER TO "alice@acme.com";