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