delete a person record permanently on IDM

Hi Gary,

As Denis suggested, depending on the version, you can configure the product so that the Person record is deleted automatically. In version 7 and up this is done at the table level, Deferred Deletion; In version 6.1.x this is the config parm QER\Person\User\DeleteDelay. You'll find more on this in the documentation.

If changing the applicable setting above is not an option you can simply "hard" delete the entries in the Person table using a SQL statement. I suggest caution on the latter however, and depending on the status of the Person record there could potentially be table references that won't allow for the delete.

Please be sure you have a recent database backup before deleting anything.

Trevor

Hi Gary,

As Denis suggested, depending on the version, you can configure the product so that the Person record is deleted automatically. In version 7 and up this is done at the table level, Deferred Deletion; In version 6.1.x this is the config parm QER\Person\User\DeleteDelay. You'll find more on this in the documentation.

If changing the applicable setting above is not an option you can simply "hard" delete the entries in the Person table using a SQL statement. I suggest caution on the latter however, and depending on the status of the Person record there could potentially be table references that won't allow for the delete.

Please be sure you have a recent database backup before deleting anything.

Trevor