Mass change on user profiles

15 pts.
Tags:
AS/400 commands
AS/400 user profiles
User profiles
Is there an easy way to do a mass change on user profile fields.  We have approx 6000 user profiles and need a way to programmatically change

Answer Wiki

Thanks. We'll let you know when a new response is added.

run a DSPUSRPRF to an outfile, and write a function which runs a CHGUSRPRF for each record, according to what you wish to do.

You will need appropriate security to do this.

Discuss This Question: 6  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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Pat419
    Do you have an example of how to write a function which runs a CHGUSRPRF cmd to read the records in the outfile
    15 pointsBadges:
    report
  • philpl1jb
    Issues -
      DANGER
    you will change every profile that is in the file if you have authority to change them INCLUDING QSYSOPR, and other critical profiles. Authority issues apply. Here is a rough draft of the cl program DCLF myfile loop: rcvf monmsg cpf0864 EXEC (GOTO CMDLBL(END)) CHGUSRPRF PWDEXP(*yes) <-- here is where you specify the change(s) go to loop END: ENDPGM
    49,570 pointsBadges:
    report
  • philpl1jb
    command should be .... CHGUSRPRF &UPUPRF ... with keywords and values to change it to &UPUPRF is the field from the file you created of user profiles. Phil
    49,570 pointsBadges:
    report
  • TomLiotta
    You might use Management Central in iSeries Navigator. Right-click the Endpoint. Select Users and groups-> Edit users... Click the Browse button and select all user profiles you want to change. Pick the Category, then select the Setting you want to change. Click the Properties button to enter the setting value. (The Properties button is in the right-hand margin in my window.) After you have all Settings/Properties set, click the OK button. Tom
    125,585 pointsBadges:
    report
  • HMSSL2K
    In your outfile, run a QRY over it to leave out IBM, and other profiles you don't wish to change.
    3,175 pointsBadges:
    report
  • HMSSL2K
    1. DSPUSRPRF *ALL OUTPUT(*OUTFILE) OUTFILE(lib/file) 2. Run SQL or QRY to create a new file with just the user profiles you want to change. 3. DCLF lib/file 4. DCL variables for the changes you want to make and set their Initial value. 5. loop through you file to you come to EOF.
    3,175 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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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

Following