Deleting User Information From Database Tables
For organizations that have to strictly comply with the GDPR regulations, use the SQL scripts recommended below to delete specific user information from the Monitor database tables.
To delete user information from database tables you can use a simple SQL statement, for example, update <TableName> set <ColumnName> = 'Unknown' where <ColumnName> = <Old Value>.
The following database tables contain specific user information in the specified columns:
Table | Column |
PRA_PROCESS_ACTION | USERNAME |
PRA_PROCESS_STEP | USERNAME |
WMCONTROL | USERNAME |
WMPROCESSDEFINITION | CREATEDBY |
WMPROCESSTASK | CREATEDBY, UPDATEDBY |
WMPROCESSTASKUSER | TASKUSER |