ALTER ORGANIZATION USER¶

Modifies the properties of an existing organization user.

See also:: CREATE ORGANIZATION USER , DROP ORGANIZATION USER , SHOW ORGANIZATION USERS

语法

ALTER ORGANIZATION USER [ IF EXISTS ] <name> SET [ objectProperties ]

ALTER ORGANIZATION USER <name> UNSET [ objectProperties ]

其中：

objectProperties ::=
  EMAIL = '<string>'
  DISPLAY_NAME = '<string>'
  FIRST_NAME = '<string>'
  MIDDLE_NAME = '<string>'
  LAST_NAME = '<string>'
  COMMENT = '<string>'

参数

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 ...: Set object properties. For a description of the object properties, see CREATE ORGANIZATION USER.
UNSET ...: Unset object properties. For a description of the object properties, see CREATE ORGANIZATION USER.

访问控制要求

A role used to execute this operation must have the following privileges at a minimum:

权限	对象	备注
MANAGE ORGANIZATION USERS	账户	默认情况下，只有组织账户中的 GLOBALORGADMIN 和 USERADMIN 系统角色具有此权限。

For instructions on creating a custom role with a specified set of privileges, see Creating custom roles.

For general information about roles and privilege grants for performing SQL actions on securable objects, see Overview of Access Control.

示例

ALTER ORGANIZATION USER alice
  SET LOGIN_NAME = 'asmith';