Deleting Actors / Users

unknown

We have created an automatic process to create, update and delete Actors and Users in RichClient linking this to any users that are created, updated and deleted in MNS150 (User profile) / MNS410 (User Role) in M3. The delete and update is not something we have done before so currently we have a mismatch of the users between M3 and RichClient mainly around 1300 users we need to delete in RichClient that no longer exist.

I have created an automatic process that will delete the users in the below tables but wanted to see what you guys thought of me doing directly in the database rather than via the flow.

The tables we are deleting from, using the landmark transactions, are as follows

PfiMetric
PfimetricSummary
PFIUserProfile
Actor
Actor Role
Identity Actor
Identity

Are you aware of any other tables that need to be deleted from (I have read about ActorContext but these tables are empty in our environments)?

Also, there is a CompleteActorDelete as a Landmark transaction and I wanted to understand what this does? Does this just delete from the Actor table or are there more tables this will delete from and if so do you know where?

Once we have the mismatch sorted, we will just use the IPA flow process to run any changes, creates or deletes to any users or roles from M3.

Thanks

Alex

unknown

It is usually not a good idea to delete user directly in the database. I have not used the Landmark transaction CompleteActorDelete, but that would probably be a better way to go. When we have users leave the company we only disable their login and delete their roles. We don't delete them completely. Good luck.