RE: Bulk delete of user profiles

Thanks for the suggestions.

As there was no way to set filters to select the profiles to be deleted I
ended up writing a program.

I had an excel list of the profiles to be deleted so I used the excel
concatenate function to create the dltusrprf command and the profile name
etcetera.

Then copy and paste into RDi.

Compile
Run

Done in 11 minutes.


Don







From: "Rob Berendt" <rob@xxxxxxxxx>
To: "Midrange Systems Technical Discussion"
<midrange-l@xxxxxxxxxxxxxxxxxx>
Date: 19/01/2021 10:31 PM
Subject: RE: Bulk delete of user profiles
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxxxxxxxx>



There's a few parts:
- Selecting the user profiles
- Determining what actions should be taken with objects they own.
- Deleting the user profiles

You could write a program to cycle through this:
https://urldefense.proofpoint.com/v2/url?u=https-3A__www.ibm.com_support_knowledgecenter_ssw-5Fibm-5Fi-5F74_rzajq_rzajqviewuserinfo.htm&d=DwICAg&c=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM&r=Kys-lxRCMpPr7up01Pp1FRjOe49ne6imWwi1b-ue8yQ&m=-U-GyW-Nd1CM0nAhRfsrbuov-yEeIJNjMIqBGvsz7pg&s=F7LHPN8qTkfnhy1IL8JOmKYgn76G3pG18cUsj01hTHY&e=


If you want to just delete the owned objects, or just assign all of them
to someone else those are options on DLTUSRPRF ... OWNOBJOPT(*CHGOWN SSA)
If you want to be more granular on it there's
https://urldefense.proofpoint.com/v2/url?u=https-3A__www.ibm.com_support_knowledgecenter_ssw-5Fibm-5Fi-5F74_rzajq_rzajqviewobjown.htm&d=DwICAg&c=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM&r=Kys-lxRCMpPr7up01Pp1FRjOe49ne6imWwi1b-ue8yQ&m=-U-GyW-Nd1CM0nAhRfsrbuov-yEeIJNjMIqBGvsz7pg&s=i5bH7tGOGIfIQo46kCX59cpOLKCTXhM-j9tu5nkB6Bo&e=


If you got some grit you could write this all as an SQL stored procedure.
Set up a cursor on user_info, call this
https://urldefense.proofpoint.com/v2/url?u=https-3A__www.ibm.com_support_knowledgecenter_ssw-5Fibm-5Fi-5F74_rzajq_rzajqprocqcmdexc.htm&d=DwICAg&c=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM&r=Kys-lxRCMpPr7up01Pp1FRjOe49ne6imWwi1b-ue8yQ&m=-U-GyW-Nd1CM0nAhRfsrbuov-yEeIJNjMIqBGvsz7pg&s=KopG_5cwd5GWKqF_k68tqFutk1Zt_K3ANTn9S780XCk&e=

to call either DLTUSRPRF, or CHGOBJOWN or CHGOWN then DLTUSRPRF

Rob Berendt