USERS
Provides information about all users in the database.
To see if a role has been assigned to a user, call the function HAS_ROLE.
| Column Name | Data Type | Description |
|---|---|---|
USER_ID
|
|
A unique numeric ID assigned by the Vertica catalog, which identifies the user. |
USER_NAME
|
|
The user name for which information is listed. |
IS_SUPER_USER
|
|
A system flag, where t (true) identifies the superuser created at the time of installation. All other users are denoted by f (false). |
PROFILE_NAME
|
|
The name of the profile to which the user is assigned. The profile controls the user's password policy. |
IS_LOCKED
|
|
Whether the user's account is locked. A locked user cannot log into the system. |
LOCK_TIME
|
|
When the user's account was locked. Used to determine when to automatically unlock the account, if the user's profile has a |
RESOURCE_POOL
|
|
The resource pool to which the user is assigned. |
MEMORY_CAP_KB
|
|
The maximum amount of memory a query run by the user can consume, in kilobytes. |
TEMP_SPACE_CAP_KB
|
|
The maximum amount of temporary disk space a query run by the user can consume, in kilobytes. |
RUN_TIME_CAP
|
|
The maximum amount of time any of the user's queries are allowed to run. |
MAX_CONNECTIONS
|
VARCHAR
|
The maximum number of connections allowed for this user. |
CONNECTION_LIMIT_MODE
|
VARCHAR
|
Indicates whether the user sets connection limits through the node or in database mode. |
IDLE_SESSION_TIMEOUT
|
VARCHAR
|
The time the system waits before timing out the user's idle session. Maximum value is 1 year. See Interval Subtype Units for valid intervals. |
GRACE_PERIOD
|
VARCHAR
|
Specifies how long a user query can block on any session socket, while awaiting client input or output. If the socket is blocked for a continuous period that exceeds the grace period setting, the server shuts down the socket and throws a fatal error. The session is then terminated. |
ALL_ROLES
|
|
Roles assigned to the user. An asterisk in ALL_ROLES output means role granted WITH ADMIN OPTION. See Database Roles in the Administrator's Guide. |
DEFAULT_ROLES
|
|
Default roles assigned to the user. An asterisk in |
SEARCH_PATH
|
|
Sets the default schema search path for the user. See Setting Search Paths in the Administrator's Guide. |
LDAP_DN
|
|
Indicates whether or not the Vertica Analytic Database user maps to an LDAP Link user. When the column is set to dn, the Vertica user maps to LDAP Link.. |
LDAP_URI_HASH
|
|
The URI hash number for the LDAP user. |
IS_ORPHANED_FROM_LDAP
|
|
Indicates if the user is disconnected (orphaned) from LDAP, set to one of the following:
For more information see Troubleshooting LDAP Link Issues |