| name |
string |
User name |
| password |
string |
Password |
| login_name |
string |
Login name |
| display_name |
string |
Display name |
| first_name |
string |
First name |
| middle_name |
string |
Middle name |
| last_name |
string |
Last name |
| email |
string |
Email address |
| must_change_password |
boolean |
Does this user need to change their password (e.g., after assigning a temp password) |
| disabled |
boolean |
Has this user been disabled from the system |
| days_to_expiry |
integer |
How many days until this user expires |
| mins_to_unlock |
integer |
How many minutes until the account is unlocked after multiple failed logins |
| default_warehouse |
string |
The default warehouse to use when this user starts a session |
| default_namespace |
string |
The default namespace to use when this user starts a session |
| default_role |
string |
The default role to use when this user starts a session |
| default_secondary_roles |
string |
The default secondary roles of this user to use when starting a session. Only valid set values are ALL or NONE. Default is ALL after 2024-07 BCR. |
| mins_to_bypass_mfa |
integer |
How many minutes until MFA is required again |
| rsa_public_key |
string |
RSA public key of the user |
| rsa_public_key_2 |
string |
Second RSA public key of the user |
| comment |
string |
Comment about the user. |
| type |
string |
Indicates the type of user (PERSON | SERVICE | LEGACY_SERVICE) |
| enable_unredacted_query_syntax_error |
boolean |
Whether to show unredacted query syntax errors in the query history. |
| network_policy |
string |
Specifies an existing network policy is active for the user. Otherwise, use account default. |
| created_on |
string |
|
| last_successful_login |
string |
|
| expires_at |
string |
|
| locked_until |
string |
|
| has_password |
boolean |
|
| has_rsa_public_key |
boolean |
|
| rsa_public_key_fp |
string |
Fingerprint of the user's RSA public key |
| rsa_public_key_2_fp |
string |
Fingerprint of the user's second RSA public key |
| ext_authn_duo |
boolean |
|
| ext_authn_uid |
string |
|
| owner |
string |
|
| snowflake_lock |
boolean |
Whether the user, account, or organization is locked by Snowflake. |
| snowflake_support |
boolean |
Whether Snowflake Support is allowed to use the user or account |
| mins_to_bypass_network_policy |
integer |
Temporary bypass network policy on the user for a specified number of minutes |
| password_last_set |
string |
|
| custom_landing_page_url |
string |
|
| custom_landing_page_url_flush_next_ui_load |
boolean |
Whether or not to flush the custom landing page of the user on next UI load |