Extend SHOW USERS, SHOW TERSE USERS, and SELECT FROM account_usage.users: New columns¶
Attention
This behavior change is in the 2024_06 bundle.
For the current status of the bundle, refer to Bundle History.
When this behavior change bundle is enabled, the SHOW USERS, SHOW TERSE USERS, and SELECT FROM account_usage.users includes the following new columns:
Column name |
Data type |
Description |
|---|---|---|
TYPE |
VARCHAR |
Specifies the type of user. PERSON, SERVICE, LEGACY_SERVICE, or NULL. Default: NULL. For more information about types of users, see the TYPE object property of users. |
HAS_MFA |
BOOLEAN |
Specifies whether the user is enrolled for multi-factor authentication. |
This change also changes the order of the returned columns, so if you use ordinals to select from these columns, then you need to change the ordinals.
Ref: 1690