News
Abstract
The USER_INFO_BASIC view contains information about user profiles.
This view returns a subset of columns that are returned by the USER_INFO view. It does not return: USER_OWNER , USER_CREATOR, SIZE, CREATION_TIMESTAMP, LAST_USED_TIMESTAMP, DAYS_USED_COUNT, or LAST_RESET_TIMESTAMP. USER_INFO_BASIC typically performs much better than USER_INFO.
Content
You are in: IBM i Technology Updates > Db2 for i - Technology Updates > IBM i Services (SQL) > QSYS2.USER_INFO_BASIC
For complete detail, visit this IBM Documentation page: USER_INFO_BASIC view
Enhanced with IBM i 7.6 SF99960 Level 1:
- New columns for multifactor authentication information: USE_EXIT_PROGRAM_AUTHENTICATION, TOTP_KEY_EXISTS, TOTP_KEY_LAST_CHANGED, USE_TOTP_AUTHENTICATION, TOTP_INTERVAL, TOTP_REMAINING_MINUTES
Enhanced with IBM i 7.5 SF99950 Level 5:
- The USER_DEFAULT_PASSWORD column always returns the null value
[{"Type":"MASTER","Line of Business":{"code":"LOB68","label":"Power HW"},"Business Unit":{"code":"BU070","label":"IBM Infrastructure"},"Product":{"code":"SWG60","label":"IBM i"},"ARM Category":[{"code":"a8m0z0000001go6AAA","label":"IBM i Db2-\u003ESQL Services \/ table functions"}],"ARM Case Number":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.3.0;and future releases"}]
Was this topic helpful?
Document Information
Modified date:
29 March 2025
UID
ibm16442011