Skip to content

User Data Anonymization#

Overview#

Critical Manufacturing MES records the account of the user who creates or changes an object in the CreatedBy and ModifiedBy properties. When the MES replicates entity data to the Data Platform, it replaces each of these accounts with the ID of the user, so the entity data stored in the Data Platform does not hold them.

The Data Manager turns the user ID back into the identity of the user when it returns the data, but only for users with the CmfDataSet.IdentityAccess security feature. Users without the security feature see the user ID.

This applies to all data read through the Data Manager:

  • Data Sets queried through OData, for example from Grafana, Power BI, or Excel.
  • Reports in Analytics Views.

What Is Anonymized#

The MES anonymizes the CreatedBy and ModifiedBy values in the following data:

Data Columns Where the value is
Entity tables in the Operational Data Store (ODS), such as CoreDataModel_T_Material CreatedBy, ModifiedBy In the column.
Tables built from an IoT Event Definition in the Canonical Data Model (CDM) CreatedBy and ModifiedBy of the main entity, and ModifiedBy of each entity it references In the property of the event.

Table: Data where user accounts are replaced by user IDs

Each value takes one of the following forms:

Case Value
The account belongs to a user of the MES. The ID of the user, for example 42.
The account does not belong to any user, for example a removed user or a service account that is not a user. -1
There is no account. Empty

Table: Anonymized values

A value of -1 cannot be turned back into an identity, even for users who hold the CmfDataSet.IdentityAccess security feature.

What Is Not Anonymized#

Only CreatedBy and ModifiedBy of the tables above are anonymized. The following data keeps the user account:

  • The _CreatedBy and _ModifiedBy columns of smart tables and generic tables.
  • The system tables of the ODS, such as Security_T_User or Config_T_Config, which hold the row as a JSON document in the Data column.
  • The _CreatedBy column of dbo_T_ServiceHistory.
  • Other properties that hold a user account, such as the user of a signature or the owner of an object.

If such a column must not reach the users of a Data Set, leave it out of the query of the Data Set.

User data anonymization does not apply to Employee data. The system reports show the ID of the Employee, and the CmfDataSet.IdentityAccess security feature does not change it.

Showing User Identities#

The Data Manager shows the identity of a user in the form User Name (User Account), for example John Smith (jsmith), when both of the following are true:

Who Can See User Identities#

  • Administrators always hold the CmfDataSet.IdentityAccess security feature.
  • When the GUI Feature Level security is inactive, every user holds it. For more information, see Security Levels.
  • Any other user holds it only through a role. To grant it, assign the feature to a role of the user. For more information, see Assigning Roles to a Feature.

On a new installation, no role holds the feature. A system upgraded from version 11.2.3 or later keeps the assignments made by that version, which assigned the feature to every role that existed at the time.

The Data Manager keeps the result of the feature check for 10 minutes. A change to the roles of a user, or to the roles assigned to the feature, can take up to 10 minutes to apply.

User Identifier Fields#

The User Identifier option is enabled by default on the system Data Sets and IoT Event Definitions of the MES. For any Data Set or IoT Event Definition that you create, enable the option yourself on each field that holds a user ID.

Enterprise Data Platform and Data Silos#

When you operate in Enterprise Data Platform (EDP) mode, the following rules also apply:

  • For CDM and DWH tables, the query must include the AppProperties_DataSilo column. Otherwise, the Data Manager returns the user IDs. The ODS tables do not need it.
  • Rows that come from an external Data Silo always show the user ID.

Changes to User Names#

The user ID of a user does not change, so the stored data stays correct after you change the name of a user. The Data Manager receives the new name when the change to the user is replicated to the Data Platform, and shows it from then on.