ALTER ORGANIZATION USER¶

Modifies the properties of an existing organization user.

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

Syntax¶

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

ALTER ORGANIZATION USER <name> UNSET [ objectProperties ]

Copy

Where:

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

Copy

Parameters¶

name

Specifies the identifier for the organization user to alter.

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.

Access control requirements¶

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

Privilege	Object	Notes
MANAGE ORGANIZATION USERS	Account	By default, only the GLOBALORGADMIN has this privilege.

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.

Examples¶

ALTER ORGANIZATION USER alice
  SET LOGIN_NAME = 'asmith';

Copy