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 OpenText™ Analytics Database 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 the database user maps to an LDAP Link user. When the column is set to dn, the database 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