Using Extract Files for Updating › Delete Profiles and Authorization from Users › Operand Explanations › Example 1: Deleting a Profile from a User Group

Example 1: Deleting a Profile from a User Group

An administrator wants to delete a profile named GRP1PROF from all the users who are in a maintenance authorization group named USERGRP1. The administrator uses the following control statements:

EXTRACT GIVING(GRP1USRS) USER AND NO SESSIONS (UIDXGRP(USERGRP1)) 
DELETE USERPROFILE USING(GRP1USRS) (GRP1PROF)

The EXTRACT statement produces the extract file named GRP1USRS, which contains the merged user definition for each user who is in the maintenance authorization group named USERGRP1. The DELETE statement deletes the profile named GRP1PROF from each user record in the extract file.