Protected Tables in DHIS2 Databases

This information is most likely relevant to DHIS2 app developers, those writing SQL queries, or someone that encounters an error similar to SQL query contains references to protected tables

According to the DHIS2 code base, the following tables are “protected”:

users
userinfo
trackedentityattribute
trackedentityattributevalue
oauth_access_token
oauth2client

These tables are protected mostly because they could contain reference to personally identifiable information, or in the case of the Oauth tables, they could provide access to the system wherein PII and client data is stored.

https://github.com/dhis2/dhis2-core/blob/master/dhis-2/dhis-api/src/main/java/org/hisp/dhis/sqlview/SqlView.java#L60

public static final Set<String>
PROTECTED_TABLES = ImmutableSet.<String> builder().add(
        "users",
        "userinfo",
        "trackedentityattribute",
        "trackedentityattributevalue",
        "oauth_access_token",
        "oauth2client" ).build();