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

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.

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 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

VARCHAR

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

VARCHAR

Default roles assigned to the user. An asterisk in DEFAULT_ROLES output means role granted WITH ADMIN OPTION. See Enabling Roles Automatically in the Administrator's Guide.

SEARCH_PATH

VARCHAR

Sets the default schema search path for the user. See Setting Search Paths in the Administrator's Guide.

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