USERS

Provides information about all users in the database.

Provides information about all users in the database.

Column Name Data Type Description
USER_ID INTEGER A unique numeric ID assigned by the Vertica catalog, which identifies the user.
USER_NAME VARCHAR The user name for which information is listed.
IS_SUPER_USER BOOLEAN 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 VARCHAR The name of the profile to which the user is assigned. The profile controls the user's password policy.
IS_LOCKED BOOLEAN Whether the user's account is locked. A locked user cannot log into the system.
LOCK_TIME TIMESTAMPTZ When the user's account was locked. Used to determine when to automatically unlock the account, if the user's profile has a PASSWORD_LOCK_TIME parameter set.
RESOURCE_POOL VARCHAR The resource pool to which the user is assigned.
MANAGED_BY_OAUTH2_AUTH_ID INTEGER The ID of the OAuth authentication record used to authenticate and provision the user, if any.
LAST_LOGIN_TIME TIMESTAMPTZ

The last time the user logged in.

MEMORY_CAP_KB VARCHAR The maximum amount of memory a query run by the user can consume, in kilobytes.
TEMP_SPACE_CAP_KB VARCHAR The maximum amount of temporary disk space a query run by the user can consume, in kilobytes.
RUN_TIME_CAP VARCHAR 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

How the user handles idle session timeout limits, one of the following:

  • unlimited: There is no idle session time limit for the user.
  • default: The user's idle session time limit is the value of the DefaultIdleSessionTimeout database parameter, or if that parameter is not set or the user is a superuser, there is no timeout limit. To view the value of DefaultIdleSessionTimeout parameter, use the SHOW DATABASE statement: 
    => SHOW DATABASE DEFAULT DEFAULTIDLESESSIONTIMEOUT;
  • Interval literal: Interval after which the user's idle session is disconnected.
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 VARCHAR Roles assigned to the user. An asterisk in ALL_ROLES output means role granted WITH ADMIN OPTION. See Database Roles.
DEFAULT_ROLES VARCHAR Default roles assigned to the user. An asterisk in DEFAULT_ROLES output means role granted WITH ADMIN OPTION. See Enabling roles automatically.
SEARCH_PATH VARCHAR Sets the default schema search path for the user. See Setting search paths.
LDAP_DN VARCHAR 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 INTEGER The URI hash number for the LDAP user.
IS_ORPHANED_FROM_LDAP BOOLEAN

Indicates if the user is disconnected (orphaned) from LDAP, set to one of the following:

  • t: User is orphaned

  • f : User is not orphaned

For more information see Troubleshooting LDAP link issues

See also