Listing Supplement Groups from a AS/400 user profile

750 pts.
Tags:
AS 400
I need to create a file (I am thinking from using query) that will list a user's Supplemental Group(s) as a separate line item for each supplement group listed in their profile. I need this so our security person can run a program they have for some kind of report. Is there a way to configure this using query?


Software/Hardware used:
V7R1M0
0

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • Splat
    One way to do it would be to use DSPUSRPRF to output the user profiles to an outfile then parse through UPSUPG to identify any assigned supplemental groups.
    12,845 pointsBadges:
    report
  • Splat
    Or, you could use the QSYRUSRI API in conjunction with the USRI0300 format to achieve the same end.
    12,845 pointsBadges:
    report
  • TheRealRaven
    Simplest might be to create a SQL VIEW over the *OUTFILE and present each element as a separate substring of UPSUPG.
    33,080 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: