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?


Thanks for your feedback! Did this solve your issue?

Comments (optional):


Thanks for your feedback!
We're glad it was helpful but sorry it didn’t solve your issue. If you need assistance, click Chat with Support below.
We’re sorry to hear that. Please tell us why.

 I don't like how this works.

 The answer is confusing.

 The answer didn't match what I was searching for.

Additional Comments (optional):


Thanks for your feedback! If you need assistance, click Chat with Support below.
Thanks for your feedback. Help us make our products even better by sharing details in our Idea Banks or our online Community.
Thanks for letting us know. We'll work on clarifying the information in the article. If you need assistance, click Chat with Support below.
Thanks for letting us know. We'll work on updating the search engine to return more relevant results.