Start of change

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).

End of change