Home - News ( United States | United Kingdom | Italy | Germany ) - Football scores

Showing content from https://docs.snowflake.com/en/sql-reference/sql/alter-organization-user below:

Website Navigation

• Reference
• SQL command reference
• Users, roles, & privileges

ALTER ORGANIZATION USER | Snowflake Documentation

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 ]

Copy

Where:

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

Copy

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.

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 and USERADMIN system roles in the organization account have 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.

ALTER ORGANIZATION USER alice
  SET LOGIN_NAME = 'asmith';

Copy

RetroSearch is an open source project built by @garambo | Open a GitHub Issue

Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo

HTML: 3.2 | Encoding: UTF-8 | Version: 0.7.4