USERS

This view contains information about users for a given cluster.

If you (the current user) has the GRANT permission, you can see all role-group pairs in this view. Otherwise, you will see only the pairs from groups you are part of.

Column Name	Description
`USER`	The name of a given user.
`HOST`	The hostname or IP address for a given user.
`TYPE`	The type of connection authentication.
`CONNECTIONS`	The number of connections a given user has open.
`IS_DELETED`	Whether a given user had been deleted.
`LAST_UPDATED`	The timestamp at which a given user was last updated.
`DEFAULT_RESOURCE_POOL`	The default resource pool for a given user.
`IS_LOCAL`	Whether a given user is local to the node on which USERS table is being accessed or if it’s a distributed user.
`CREATED`	The timestamp at which a given user was created.
`PASSWORD_EXPIRATION`	If the `password_expiration_seconds` engine variable is not enabled, this column will be NULL. If the `password_expiration_seconds` engine variable is enabled, the column will display the number of seconds remaining for the password to expire.
`PASSWORD_UPDATED`	The timestamp a given user’s password was last updated.
`EFFECTIVE_FAILED_LOGIN_ATTEMPTS`	The number of failed login attempts for a given user.
`EFFECTIVE_PASSWORD_LOCK_TIME`	The amount of time, in milliseconds, a given user’s account has been locked due to failed login attempts.
`ACCOUNT_STATUS`	Whether a given user account is `LOCKED` due to failed login attempts exceeding the set limit, or if the account is `OPEN`. `N/A` means that a policy has not been set for exceeding login attempts.
`ATTRIBUTE`	An optional user field. A JSON object set by including `ATTRIBUTE` as part of ``CREATE USER` or `ALTER USER`.
`COMMENT`	An optional user comment text string for the user. A comment is set by including `COMMENT` as part of `CREATE USER` or `ALTER USER`.

Last modified: April 12, 2023

Was this article helpful?