Update user

Update a user in Snowflake.

Options

Field	Definition	Type	Required
Pass Empty Values	Choose whether to pass empty values to the remote system, instead of skipping an update to the field. Yes: For any input field on the card that's blank or given a null value, the update includes the empty field. This clears any existing value on the remote system for that field. No: For any input field on the card that's blank or given a null value, nothing is sent to the remote system for this field. Any existing value on the remote system remains unchanged.	Dropdown	TRUE
User Type	The type of user. Person: The user is a human user who can interact with Snowflake. Service: The user is a service or app that interacts with Snowflake without human interaction. Legacy service: Similar to Service, but also allows password and SAML authentication.	Dropdown	FALSE

Field

Definition

Type

Required

Pass Empty Values

Choose whether to pass empty values to the remote system, instead of skipping an update to the field.

Yes: For any input field on the card that's blank or given a null value, the update includes the empty field. This clears any existing value on the remote system for that field.
No: For any input field on the card that's blank or given a null value, nothing is sent to the remote system for this field. Any existing value on the remote system remains unchanged.

TRUE

User Type

The type of user.

Person: The user is a human user who can interact with Snowflake.
Service: The user is a service or app that interacts with Snowflake without human interaction.
Legacy service: Similar to Service, but also allows password and SAML authentication.

FALSE

Input

Field	Definition	Type	Required
User
User Name	Username of the user.	Text	TRUE
Login Name	The name the user uses to sign in.	Text	FALSE
Display Name	Name displayed for the user.	Text	FALSE
First Name	Given name of the user.	Text	FALSE
Middle Name	Middle name of the user.	Text	FALSE
Last Name	Last name of the user.	Text	FALSE
Email	The email address of the user.	Text	FALSE
Days to Expiry	The number of days after which the user status is set to Expired and is no longer allowed to sign in.	Number	FALSE
Mins To Unlock	The number of minutes until the temporary lock on the user sign-in is cleared.	Number	FALSE
RSA Public Key	The RSA public key of the user.	Text	FALSE
RSA Public Key 2	The second RSA public key of the user.	Text	FALSE
Comment	A comment about the user.	Text	FALSE
Mins To Bypass MFA	The number of minutes until MFA is required again.	Number	FALSE
Must Change Password	If true, the user is forced to change their password on their next sign-in, including their first sign-in.	True/False	FALSE
Is Disabled	If true, the user is locked out of Snowflake and can't sign back in.	True/False	FALSE
Default Warehouse	A virtual warehouse that's active by default for the user's session upon signing in.	Text	FALSE
Default Namespace	The namespace that's active by default for the user's session upon signing in.	Text	FALSE
Default Role	The primary role that's active by default for the user's session upon signing in.	Text	FALSE
Default Secondary Roles	The default secondary roles of this user to use when starting a session. The only valid values are ALL or NONE.	Dropdown	FALSE
Enable Unredacted Query Syntax Error	If false, the contents of a failed query are redacted from the views, pages, and functions that provide a query history.	True/False	FALSE
Network Policy	Specifies an existing network policy is active for the user. Otherwise, it uses the account default.	Text	FALSE

Output

Field	Definition	Type
Result
Status Code	The status code returned by the server.	Number
Status	The status message returned by the server.	Text

Update user

Options

Input

Output

Related topics