How do you inactivate a large group of users?

The client has requested a large number of Users be inactivated. Normally on only needs to go into 'User Entry' and change the user status from 'A' to 'I', however it would be time consuming and tedious to do it for dozens or even hundreds for former users.
The client should provide a spreadsheet with a list of all users that they want inactivated.  The table that you want to use is User_Name, which does NOT use account_id as a factor.  The information you need from the client would be User_Name and Status.

1.  Import this data into a temp table in the client's database. (in the example below we called it XXX_CASENO_INACTIVATE_USERS)
2.  Use this update statement to inactivate the records:

UPDATE USER_NAMES UN SET UN.STS = 'I' 
WHERE UN.USER_NAME IN (SELECT IU.USER_NAME FROM XXX_CASENO_INACTIVATE_USERS IU)
AND UN.STS = 'A';
 

Environment

 RSR
 TA

Was this article helpful?