ALTER ACCOUNT
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
| Parameter | Description |
|---|---|
<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
| Parameter | Description |
|---|---|
<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";