USER_INFO view
The USER_INFO view contains information about user profiles.
The USER_INFO_BASIC view returns a subset of this information and is faster.
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: The caller must have *OBJOPR and *READ authorities to the *USRPRF. To see a non-null value for the USER_DEFAULT_PASSWORD column, the caller must have *ALLOBJ and *SECADM authorities.
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. Contains null if the profile has never been used to sign 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.
Contains one of the following values:
|
NETSERVER_DISABLED | NETSERVER | VARCHAR(3) | Whether this user profile is disabled for IBM® i NetServer use.
|
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_LEVEL_0_1 | PWD_0_1 | VARCHAR(3) Nullable
|
Indicates whether the user profile has a password that can be
used for a system at QPWDLVL 0 or 1.
Contains the null value if NO_PASSWORD_INDICATOR has a value of YES. |
PASSWORD_LEVEL_2_3 | PWD_2_3 | VARCHAR(3) Nullable
|
Indicates whether the user profile has a password that can be
used for a system at QPWDLVL 2 or 3.
Contains the null value if NO_PASSWORD_INDICATOR has a value of YES. |
![]() ![]() |
![]() ![]() |
![]() Nullable
![]() |
![]()
Contains the null value if NO_PASSWORD_INDICATOR has a value of YES. ![]() |
PASSWORD_EXPIRATION_INTERVAL | PWDEXPITV | SMALLINT Nullable
|
The number of days (from 1 through
366) the user's password can remain active before it must be changed.
Can also be one of the following values:
|
DATE_PASSWORD_EXPIRES | PWDEXPDAT | TIMESTAMP Nullable
|
The date the user's password expires. Contains null if the password will not expire. |
DAYS_UNTIL_PASSWORD_EXPIRES | PWDDAYSEXP | INTEGER Nullable
|
The number of days until the password
will expire. A value of 0 indicates the password is expired. 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. Contains one of the following values:
|
USER_CLASS_NAME | USRCLS | VARCHAR(10) Nullable
|
The user's class name. Contains
one of the following values:
|
SPECIAL_AUTHORITIES | SPCAUT | VARCHAR(88) Nullable
|
A list of the special authorities
the user has. Up to 8 authorities are returned. Each entry is padded
with blanks to fill 11 characters. Contains null if the user has no special authorities. |
GROUP_PROFILE_NAME | GRPPRF | VARCHAR(10) Nullable
|
The name of the group profile. Contains the value *NONE if the user does not have a 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. Contains one of the following values:
|
GROUP_AUTHORITY | GRPAUT | VARCHAR(10) Nullable
|
The authority the user's group
profile has to objects the user creates. Contains one of the following
values:
|
ASSISTANCE_LEVEL | ASTLVL | VARCHAR(10) Nullable
|
The user interface that the user
will use. Contains one of the following values:
|
CURRENT_LIBRARY_NAME | CURLIB | VARCHAR(10) Nullable
|
The name of the user's current library. Contains *CRTDFT if the user does not have a current library. |
INITIAL_MENU_NAME | INLMNU | VARCHAR(10) Nullable
|
The initial menu for the user. Can contain the special value *SIGNOFF. |
INITIAL_MENU_LIBRARY_NAME | INLMNULIB | VARCHAR(10) Nullable
|
The name of the library that the
initial menu is in. Can contain the special value *LIBL. Contains null if the menu name is *SIGNOFF. |
INITIAL_PROGRAM_NAME | INITPGM | VARCHAR(10) Nullable
|
The initial program for the user. Contains *NONE if there is no initial program. |
INITIAL_PROGRAM_LIBRARY_NAME | INITPGMLIB | VARCHAR(10) Nullable
|
The name of the library that the
initial program is in. Can contain the special value *LIBL. Contains null if the initial program name is *NONE. |
LIMIT_CAPABILITIES | LMTCPB | VARCHAR(10) Nullable
|
Indicates whether the user has
limited capabilities. Contains one of the following values:
|
TEXT_DESCRIPTION | TEXT | VARCHAR(50) Nullable
|
The descriptive text for the user
profile. Contains null if the user profile has no text description. |
DISPLAY_SIGNON_INFORMATION | DSPSGNINF | VARCHAR(10) Nullable
|
Indicates whether the sign-on information
display is shown when the user signs on. Contains one of the following
special values:
|
LIMIT_DEVICE_SESSIONS | LMTDEVSSN | VARCHAR(10) Nullable
|
Specifies if the number of device
sessions allowed for a user is limited. Can contain one of the following
special values:
|
KEYBOARD_BUFFERING | KBDBUF | VARCHAR(10) Nullable
|
The keyboard buffering value that
is used when a job is initialized for this user. Contains one of the
following special values:
|
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. Can contain the special value *LIBL. |
ACCOUNTING_CODE | ACGCDE | VARCHAR(15) Nullable
|
The accounting code that is associated
with this user. Contains null if there is no accounting code. |
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. Can contain the special value *LIBL. |
MESSAGE_QUEUE_DELIVERY_METHOD | DLVRY | VARCHAR(10) Nullable
|
How the messages are delivered
to the message queue used by the user. Contains one of the following
values:
|
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.
Can contain one of the following special values:
|
OUTPUT_QUEUE_LIBRARY_NAME | OUTQLIB | VARCHAR(10) Nullable
|
The name of the library where the
output queue is located. Contains null if the output queue name is *DEV or *WRKSTN. |
PRINT_DEVICE | PRTDEV | VARCHAR(10) Nullable
|
The printer used to print for this
user. Can contain one of the following special values:
|
SPECIAL_ENVIRONMENT | SPCENV | VARCHAR(10) Nullable
|
The special environment the user
operates in after signing on. Contains one of the following special
values:
|
ATTENTION_KEY_HANDLING_
PROGRAM_NAME |
ATNPGM | VARCHAR(10) Nullable
|
The attention key handling program
for this user. Can contain one of the following special values:
|
ATTENTION_KEY_HANDLING_
PROGRAM_LIBRARY_NAME |
ATNPGMLIB | VARCHAR(10) Nullable
|
The name of the library where the
program is located. Can contain the special value *LIBL. Contains null if the attention key handling program is *NONE or *SYSVAL. |
LANGUAGE_ID | LANGID | VARCHAR(10) Nullable
|
The language ID used by the system
for this user. Can contain the following special value:
|
COUNTRY_OR_REGION_ID | CNTRYID | VARCHAR(10) Nullable
|
Country or region ID. Can contain
the following special value:
|
CHARACTER_CODE_SET_ID | CCSID | VARCHAR(6) Nullable
|
The CCSID for the user. Can contain
the following special value:
|
USER_OPTIONS | USROPT | VARCHAR(77) Nullable
|
A list of the options for users
to customize their environment. Up to 7 options are returned. Each
entry is padded with blanks to fill 11 characters. 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. Can contain one of the following special
values:
|
SORT_SEQUENCE_TABLE_LIBRARY_NAME | SRTSEQLIB | VARCHAR(10) Nullable
|
The name of the library that is
used to locate the sort sequence table. Contains null if the sort sequence table is a special value. |
OBJECT_AUDITING_VALUE | OBJAUD | VARCHAR(10) Nullable
|
The object auditing value for this
user. Contains one of the following values:
|
USER_ACTION_AUDIT_LEVEL | AUDLVL | VARCHAR(363) Nullable
|
The action audit values for this
user. Up to 31 options are returned. Each entry is padded with blanks
to fill 11 characters. Contains null if there are no action values or if the caller is not authorized to retrieve the action audit level. |
GROUP_AUTHORITY_TYPE | GRPAUTTYP | VARCHAR(10) Nullable
|
The type of authority the user's
group profile has to objects the user creates. Contains one of the
following special values:
|
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 profile. The value 0 is returned if the user has no group ID number. |
LOCALE_JOB_ATTRIBUTES | SETJOBATR | VARCHAR(88) Nullable
|
A list of the job attributes that are taken from the user's locale path. This column contains a list of up to 8 items. Each entry is padded with blanks to fill 11 characters. |
GROUP_MEMBER_INDICATOR | GRPMBR | VARCHAR(3) Nullable
|
Whether this user is a group that
has members. Contains one of the following values:
|
DIGITAL_CERTIFICATE_INDICATOR | DCIND | VARCHAR(3) Nullable
|
Whether there are digital certificates
associated with this user. Contains one of the following values:
|
CHARACTER_IDENTIFIER_CONTROL | CHRIDCTL | VARCHAR(10) Nullable
|
The character identifier control
for the user. Can contain the following special values:
|
LOCAL_PASSWORD_MANAGEMENT | LCLPWDMGT | VARCHAR(3) Nullable
|
Indicates if password is managed
locally. Contains one of the following values:
|
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. Can contain one of the
following special values:
|
USER_ENTITLEMENT_REQUIRED | ENTITLERQD | VARCHAR(3) Nullable
|
Whether a user entitlement is required
for this user profile. Contains one of the following values:
|
USER_EXPIRATION_INTERVAL | USREXPITV | SMALLINT Nullable
|
The number of days (from 1 through 366) before the user profile is automatically disabled. The value 0 is returned if no expiration interval is defined. |
USER_EXPIRATION_DATE | USREXPDATE | TIMESTAMP Nullable
|
The date when the user profile
expires and is automatically disabled or deleted. Contains null if the user profile will not expire. |
USER_EXPIRATION_ACTION | ACTION | VARCHAR(8) Nullable
|
The action that will occur when
the user profile has expired. Contains one of the following values:
|
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. Can contain one of the
following special values:
|
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. |
AUTHORITY_COLLECTION_ACTIVE | AUTCOLACT | VARCHAR(3) | Whether authority collection is
active for this user.
|
AUTHORITY_COLLECTION_REPOSITORY_
EXISTS |
AUTCOLREP | VARCHAR(3) | Whether an authority collection
repository exists for this user.
|
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