USERS
Warning
SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.
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.
Column Name |
Description |
---|---|
|
The name of a given user. |
|
The hostname or IP address for a given user. |
|
The type of connection authentication. |
|
The number of connections a given user has open. |
|
Whether a given user had been deleted. |
|
The timestamp at which a given user was last updated. |
|
The default resource pool for a given user. |
|
Whether a given user is local to the node on which USERS table is being accessed or if it’s a distributed user. |
|
The timestamp at which a given user was created. |
|
If the |
|
The timestamp a given user’s password was last updated. |
|
The number of failed login attempts for a given user. |
|
The amount of time, in milliseconds, a given user’s account has been locked due to failed login attempts. |
|
Whether a given user account is |
|
An optional user field. |
|
An optional user comment text string for the user. |
Last modified: April 12, 2023