Previous Next JavaScript must be enabled to correctly display this content

## 4.2.2 Using purge procedures

OBAPI provides some out of the box purge procedure that can be used to purge the data. Otherwise the DBA / IT staff can prepare similar procedures to purge required data.

However note that it is not recommended to purge or delete any data stored in OBAPI tables without doing detailed impact analysis. Please also note that the purge jobs are useful typically for purging old data. They may not be useful for purging data of a specific customer.

Procedure name -

`DIGX_USER_PII_DATA_PURGE.sql`

Procedure input parameter –

User Id (unique identifier of user) which is to be purged.

Description -

`DIGX_USER_PII_DATA_PURGE` will permanently purge the user and all the PII data associated with the user from all the database tables of OBAPI.

It must be noted that once user is purged then associated PII data and user cannot be retrieved under any circumstances.

Associated table -

This table holds data of table names and field names of tables containing User Id. Procedure fetches data from table `DIGX_UM_USERS_ASSOCIATIONS` and deletes all the PII data related to the provided User Id

Steps to run -

Run the procedure with providing User Id as input parameter.

Parent topic: Deleting or Purging PII data