Reference and syntax for the ALTER ACCOUNT command.
Updates the configuration of the specified account.
For more information, see Managing accounts.
Renames an account.
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 (-). |
The following command will rename the “dev” account to “staging”.
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.
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. |
The following command will set account “dev” owner to “alice@acme.com”.