SingleStore Managed Service

information_schema.USERS

This table 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 table. 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_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.