Administering and Monitoring Business Processes 10.5 | Administering and Monitoring Business Processes | webMethods Monitor User’s Guide | Archiving or Deleting Data in an Archive Database | Deleting User Information From Database Tables
 
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
Copyright © 2019 | Software AG, Darmstadt, Germany and/or Software AG USA, Inc., Reston, VA, USA, and/or its subsidiaries and/or its affiliates and/or their licensors.