ibmi-brunch-learn

Announcement

Collapse
No announcement yet.

USER_INFO view to list users

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • USER_INFO view to list users

    Hello,

    I'm trying to list the iSeries users sing using the USER_INFO view.
    The IBM tech info says:
    "Authorization: Only *USRPRF objects that the caller has *OBJOPR and *READ authority to will be returned. To see a non-null value for the USER_DEFAULT_PASSWORD column, the caller must have *ALLOBJ and *SECADM authority.​"

    Does that mean I can't list the same user profiles I get using DSPUSRPRF *ALL output(*outfile) ?

    the SQL returns 159 entries while DSPUSRPRF returns 499.

    thanks
    Nuno
Working...
X