Is there a SQL script to physically delete terminated (logically deleted) users in the database with all references (Change Request, etc...)?
Is your problem with storage space? Because I would never recommend any of my clients to do this. There is a reason this is a governance tool, which means you should be able to report on the past, not just the present. So any history is absolutely needed to be able to trust IAM facilitated by RSA IGL.
Hi Gerard, no it's not a storage space problem but because of a reconfiguration of the IDCs (Identity Data Collectors) done after the go-live, we have all users duplicated (same users, one entry active and another deleted/terminated; but both are exactly the same user identity).
There were similar posts:
How can a created User be deleted?
Duplication of Users in Via 7.0.0
000033880 - How to hide deleted users from the Users Section of the UI in RSA Via Lifecycle and Governance
Retrieving data ...