USER_INFO view
The USER_INFO view contains information about user profiles.
The values returned for the columns in the view are closely related to the values returned by Retrieve User Information (QSYRUSRI) API. Refer to the API for more detailed information.
Authorization: Only *USRPRF objects that the user has *OBJOPR and *READ authority to will be returned. To see a non-null value for the USER_DEFAULT_PASSWORD column, the user must have *ALLOBJ and *SECADM authority.
The following table describes the columns in the view. The schema is QSYS2.
| Column Name | System Column Name | Data Type | Description |
|---|---|---|---|
| AUTHORIZATION_NAME | USER_NAME | VARCHAR(10) Nullable
|
User profile name. |
| PREVIOUS_SIGNON | PRVSIGNON | TIMESTAMP Nullable
|
The date and time the user last signed on. |
| SIGN_ON_ATTEMPTS_NOT_VALID | SIGNONINV | INTEGER Nullable
|
The number of sign-on attempts that were not valid since the last successful sign-on. |
| STATUS | STATUS | VARCHAR(10) Nullable
|
The status of the user profile. |
| PASSWORD_CHANGE_DATE | PWDCHGDAT | TIMESTAMP Nullable
|
The date the user's password was last changed. |
| NO_PASSWORD_INDICATOR | NOPWD | VARCHAR(3) Nullable
|
Indicates whether *NONE is specified
for the password in the user profile.
|
| PASSWORD_EXPIRATION_INTERVAL | PWDEXPITV | INTEGER Nullable
|
The number of days (from 1 through 366) the user's password can remain active before it must be changed. |
| DATE_PASSWORD_EXPIRES | PWDEXPDAT | TIMESTAMP Nullable
|
The date the user's password expires. |
| DAYS_UNTIL_PASSWORD_EXPIRES | PWDDAYSEXP | INTEGER Nullable
|
The number of days until the password will expire. Contains null if the password will not expire within the number of days specified by the password expiration warning (QPWDEXPWRN) system value. |
| SET_PASSWORD_TO_EXPIRE | PWDEXP | VARCHAR(3) Nullable
|
Indicates whether the user's password is set to expire, requiring the user to change the password when signing on. |
| USER_CLASS_NAME | USRCLS | VARCHAR(10) Nullable
|
The user's class name. |
| SPECIAL_AUTHORITIES | SPCAUT | VARCHAR(88) Nullable
|
A list of the special authorities the user has. |
| GROUP_PROFILE_NAME | GRPPRF | VARCHAR(10) Nullable
|
The name of the group profile. |
| SUPPLEMENTAL_GROUP_COUNT | SUPGRPCNT | SMALLINT | The number of supplemental groups in the SUPPLEMENTAL_GROUP_LIST column. |
| SUPPLEMENTAL_GROUP_LIST | SUPGRPLIST | VARCHAR(150) Nullable
|
A list of supplemental groups for
the user profile. Up to 15 supplemental groups are returned. Each
entry except for the last one is padded with blanks to fill 10 characters. Contains null if the user has no supplemental groups. |
| OWNER | OWNER | VARCHAR(10) Nullable
|
This field indicates who is to own objects created by this user. |
| GROUP_AUTHORITY | GRPAUT | VARCHAR(10) Nullable
|
The authority the user's group profile has to objects the user creates. |
| ASSISTANCE_LEVEL | ASTLVL | VARCHAR(10) Nullable
|
The user interface that the user will use. |
| CURRENT_LIBRARY_NAME | CURLIB | VARCHAR(10) Nullable
|
The name of the user's current library. |
| INITIAL_MENU_NAME | INLMNU | VARCHAR(10) Nullable
|
The initial menu for the user. |
| INITIAL_MENU_LIBRARY_NAME | INLMNULIB | VARCHAR(10) Nullable
|
The name of the library that the initial menu is in. |
| INITIAL_PROGRAM_NAME | INITPGM | VARCHAR(10) Nullable
|
The initial program for the user. |
| INITIAL_PROGRAM_LIBRARY_NAME | INITPGMLIB | VARCHAR(10) Nullable
|
The name of the library that the initial program is in. |
| LIMIT_CAPABILITIES | LMTCPB | VARCHAR(10) Nullable
|
Indicates whether the user has limited capabilities. |
| TEXT_DESCRIPTION | TEXT | VARCHAR(50) Nullable
|
The descriptive text for the user profile. |
| DISPLAY_SIGNON_INFORMATION | DSPSGNINF | VARCHAR(10) Nullable
|
Indicates whether the sign-on information display is shown when the user signs on. |
| LIMIT_DEVICE_SESSIONS | LMTDEVSSN | VARCHAR(10) Nullable
|
Specifies if the number of device sessions allowed for a user is limited. |
| KEYBOARD_BUFFERING | KBDBUF | VARCHAR(10) Nullable
|
The keyboard buffering value that is used when a job is initialized for this user. |
| MAXIMUM_ALLOWED_STORAGE | MAXSTGLRG | BIGINT Nullable
|
The maximum amount of auxiliary storage (in kilobytes) that can be assigned to store permanent objects owned by the user. Contains null if the user has no maximum storage. |
| STORAGE_USED | STGUSED | BIGINT Nullable
|
The amount of auxiliary storage (in kilobytes) occupied by this user's owned objects on *SYSBAS. The QSYS2.USER_STORAGE catalog should be used to determine the storage consumed on all ASPs. |
| HIGHEST_SCHEDULING_PRIORITY | PTYLMT | CHAR(1) Nullable
|
The highest scheduling priority the user is allowed to have for each job submitted to the system. |
| JOB_DESCRIPTION_NAME | JOBD | VARCHAR(10) Nullable
|
The name of the job description used for jobs that start through subsystem work station entries. |
| JOB_DESCRIPTION_LIBRARY_NAME | JOBDLIB | VARCHAR(10) Nullable
|
Job description library name. |
| ACCOUNTING_CODE | ACGCDE | VARCHAR(15) Nullable
|
The accounting code that is associated with this user. |
| MESSAGE_QUEUE_NAME | MSGQ | VARCHAR(10) Nullable
|
The name of the message queue that is used by this user. |
| MESSAGE_QUEUE_LIBRARY_NAME | MSGQLIB | VARCHAR(10) Nullable
|
The name of the library the message queue is in. |
| MESSAGE_QUEUE_DELIVERY_METHOD | DLVRY | VARCHAR(10) Nullable
|
How the messages are delivered to the message queue used by the user. |
| MESSAGE_QUEUE_SEVERITY | SEV | SMALLINT Nullable
|
The lowest severity that a message can have and still be delivered to a user in break or notify mode |
| OUTPUT_QUEUE_NAME | OUTQ | VARCHAR(10) Nullable
|
The output queue used by this user. |
| OUTPUT_QUEUE_LIBRARY_NAME | OUTQLIB | VARCHAR(10) Nullable
|
The name of the library where the output queue is located. |
| PRINT_DEVICE | PRTDEV | VARCHAR(10) Nullable
|
The printer used to print for this user. |
| SPECIAL_ENVIRONMENT | SPCENV | VARCHAR(10) Nullable
|
The special environment the user operates in after signing on. |
ATTENTION_KEY_HANDLING_
PROGRAM_NAME |
ATNPGM | VARCHAR(10) Nullable
|
The attention key handling program for this user. |
ATTENTION_KEY_HANDLING_
PROGRAM_LIBRARY_NAME |
ATNPGMLIB | VARCHAR(10) Nullable
|
The name of the library where the program is located. |
| LANGUAGE_ID | LANGID | VARCHAR(10) Nullable
|
The language ID used by the system for this user. |
| COUNTRY_OR_REGION_ID | CNTRYID | VARCHAR(10) Nullable
|
Country or region ID. |
| CHARACTER_CODE_SET_ID | CCSID | VARCHAR(6) Nullable
|
The CCSID for the user. |
| USER_OPTIONS | USROPT | VARCHAR(77) Nullable
|
A list of the options for users to customize their environment. Contains null if there are no user options. |
| SORT_SEQUENCE_TABLE_NAME | SRTSEQ | VARCHAR(10) Nullable
|
The name of the sort sequence table used for string comparisons. |
| SORT_SEQUENCE_TABLE_LIBRARY_NAME | SRTSEQLIB | VARCHAR(10) Nullable
|
The name of the library that is used to locate the sort sequence table. |
| OBJECT_AUDITING_VALUE | OBJAUD | VARCHAR(10) Nullable
|
The object auditing value for this user. |
| USER_ACTION_AUDIT_LEVEL | AUDLVL | VARCHAR(341) Nullable
|
The action audit values for this user. |
| GROUP_AUTHORITY_TYPE | GRPAUTTYP | VARCHAR(10) Nullable
|
The type of authority the user's group profile has to objects the user creates. |
| USER_ID_NUMBER | UID | BIGINT Nullable
|
The user ID number for the user profile. |
| GROUP_ID_NUMBER | GID | BIGINT Nullable
|
The group ID number for the user profi |
| LOCALE_JOB_ATTRIBUTES | SETOBJATR | VARCHAR(88) Nullable
|
A list of the job attributes that are taken from the user's locale path. |
| GROUP_MEMBER_INDICATOR | GRPMBR | VARCHAR(3) Nullable
|
Whether this user is a group that has members. |
| DIGITAL_CERTIFICATE_INDICATOR | DCIND | VARCHAR(3) Nullable
|
Whether there are digital certificates associated with this user. |
| CHARACTER_IDENTIFIER_CONTROL | CHRIDCTL | VARCHAR(10) Nullable
|
The character identifier control for the user. |
| LOCAL_PASSWORD_MANAGEMENT | LCLPWDMGT | VARCHAR(3) Nullable
|
Indicates if password is managed locally. |
| BLOCK_PASSWORD_CHANGE | PWDCHGBLK | VARCHAR(10) Nullable
|
Specifies the time period, in hours, during which a password is blocked from being changed following the prior successful password change operation. |
| USER_ENTITLEMENT_REQUIRED | ENTITLERQD | VARCHAR(3) Nullable
|
Whether a user entitlement is required for this user profile. |
| USER_EXPIRATION_INTERVAL | USREXPITV | SMALLINT Nullable
|
The number of days (from 1 through 366) before the user profile is automatically disabled. |
| USER_EXPIRATION_DATE | ESREXPDATE | TIMESTAMP Nullable
|
The date when the user profile expires and is automatically disabled or deleted. |
| USER_EXPIRATION_ACTION | ACTION | VARCHAR(8) Nullable
|
The action that will occur when the user profile has expired. |
| HOME_DIRECTORY | HOMEDIR | VARGRAPHIC(1024)
CCSID 1200 Nullable |
The home directory for this user profile. |
| LOCALE_PATH_NAME | LOCALE | VARGRAPHIC(1024)
CCSID 1200 Nullable |
The locale path name that is assigned to the user profile when a job is started. |
| USER_DEFAULT_PASSWORD | DFTPWD | VARCHAR(3) Nullable
|
The password is the default password.
Contains null if not authorized to view this information. |
| USER_OWNER | USER_OWNER | VARCHAR(10) Nullable
|
The user profile that owns this user profile. |
| USER_CREATOR | CREATOR | VARCHAR(10) Nullable
|
The user profile that created this user profile. |
| SIZE | SIZE | DECIMAL(15,0) Nullable
|
Size of the user profile, in bytes. |
| CREATION_TIMESTAMP | TIMESTAMP | TIMESTAMP Nullable
|
Timestamp of when the user profile was created. |
| LAST_USED_TIMESTAMP | LASTUSED | TIMESTAMP Nullable
|
The date the user profile was used last. The time portion of the timestamp will always be 0. |
| DAYS_USED_COUNT | DAYSUSED | INTEGER Nullable
|
The number of days the user profile has been used on the system. |
| LAST_RESET_TIMESTAMP | LASTRESET | TIMESTAMP Nullable
|
The date when the days used count was last reset to zero. The time portion of the timestamp will always be 0. |
| PASE_SHELL_PATH | SHELL_PATH | VARCHAR(1024)
CCSID 1208 Nullable |
Path to the user's PASE shell.
If AUTHORIZATION_NAME is QSYS, this column
contains the default shell path used for all user profiles that have
not had a value explicitly set. Returns the null value if a value has not been set using the QSYS2.SET_PASE_SHELL_INFO procedure. |
Example
Determine which users are having trouble signing on.
SELECT * FROM QSYS2.USER_INFO
WHERE SIGN_ON_ATTEMPTS_NOT_VALID > 0