OBJECT_STATISTICS() table function changes for *USRPRF objects
In IBM® i 7.2 with PTF SI74488, the QSYS2/OBJECT_STATISTICS() table function has been modified to only return result rows for user profiles to which the user has some authority (authority other than *EXCLUDE).
With this change, any views which use the QSYS2/OBJECT_STATISTICS() table function to list user profiles may have different results than it would have had before this change. This includes the following views:
- QSYS2.AUTHORIZATIONS
- QSYS2.GROUP_PROFILE_ENTRIES
- QSYS2.OBJECT_LOCK_INFO
- QSYS2.OBJECT_PRIVILEGES
- SYSIBM.AUTHORIZATIONS
This is not a complete list, but is representative of the types of views that may change behavior.
If it is desired for result rows to be returned for all user profiles, the QSYS2/OBJECT_STATISTICS() table function should be called by a user with *ALLOBJ special authority or a user which is authorized to the Database Security Administrator function of IBM i (QIBM_DB_SECADM).