ALTER ORGANIZATION ACCOUNT¶

Modifies the properties of an existing organization account.

See also:: CREATE ORGANIZATION ACCOUNT, SHOW ORGANIZATION ACCOUNTS

语法

ALTER ORGANIZATION ACCOUNT SET { [ accountParams ] | [ objectParams ] | [ sessionParams ] }

ALTER ORGANIZATION ACCOUNT UNSET <param_name> [ , ... ]

ALTER ORGANIZATION ACCOUNT SET RESOURCE_MONITOR = <monitor_name>

ALTER ORGANIZATION ACCOUNT SET { PASSWORD | SESSION } POLICY <policy_name>

ALTER ORGANIZATION ACCOUNT UNSET { PASSWORD | SESSION } POLICY

ALTER ORGANIZATION ACCOUNT SET TAG <tag_name> = '<tag_value>' [ , <tag_name> = '<tag_value>' ... ]

ALTER ORGANIZATION ACCOUNT UNSET TAG <tag_name> [ , <tag_name> ... ]

Note

The accountParams, objectParams, and sessionParams for the organization account are identical to the parameters for other accounts. See ALTER ACCOUNT for their syntax.

参数

name

指定要更改的组织账户的标识符。

If the identifier contains spaces or special characters, the entire string must be enclosed in double quotes. Identifiers enclosed in double quotes are also case-sensitive.

For more information, see Identifier requirements.

SET ...

指定要为组织账户设置的一个（或多个）账户、会话和对象参数（用空格、逗号或换行符分隔）：

任何其他用户都无法更改的账户参数。
在账户级别设置的会话和对象参数仅用作默认值，可以由其他用户更改。

For descriptions of the parameters you can set for your organization account, see Parameters.

UNSET ...

为您的账户指定一个（或多个）要取消设置的账户、会话和对象参数，这会将它们重置为系统默认值。

You can reset multiple properties with a single ALTER statement; however, each property must be separated by a comma. When resetting a property, specify only the name; specifying a value for the property will return an error.

SET RESOURCE_MONITOR resource_monitor_name

特殊参数，用于指定资源监视器的名称，而资源监视器则用于控制账户中创建的所有虚拟仓库。

组织账户不宜大量用于分析或其他工作负载。

{ PASSWORD | SESSION } POLICY policy_name

Specifies the password policy or the session policy to set for the account.

TAG tag_name = 'tag_value' [ , tag_name = 'tag_value' , ... ]

Specifies the tag name and the tag string value.

The tag value is always a string, and the maximum number of characters for the tag value is 256.

For information about specifying tags in a statement, see Tag quotas.

访问控制要求

只有具有 GLOBALORGADMIN 角色的用户才能执行此命令。

示例

重命名组织账户，同时允许用户使用新的或旧的账户 URL 访问该账户。

ALTER ORGANIZATION ACCOUNT original_acctname RENAME TO new_acctname;