Which tables used by the plugin TROCK Timetracking Overview And Logging can contain personal data ?

Issue #44 closed
outilscollaboratifs.assu@socgen.com created an issue

Hi,

We are currently working on anonymizing our data stored in Jira.
We would like to know the completeness of the tables used by the plugin TROCK Timetracking Overview And Logging that may contain personal data.

Kind regards,
Roman.

Comments (3)

  1. Johannes Heger repo owner

    Hi Roman,

    TROCK creates a user-setting at login of a user. The data are the user-key, report type (Week, Month, Custom), start- and end-date, and the configured filter.

    The user-key is the user-name (the "login-name") if the user was created in Jira-versions before 8.4, and is of format JIRAUSER12345 if the user was created in Jira-versions starting with 8.4.

    Database

    TROCK stores the user-settings in the database-table AO_A18366_USERCONFIG. You can find table-names of add-ons in the List of Jira Server AO table names and vendors.

    REST API

    TROCK has the REST-API where a user with System-Admin permission can get all user's settings.

    Anonymization extension points not implemented

    TROCK has not implemented the anonymization extension points described in Dev docs: Anonymizing users. I don't know if I will do this because only users with system-admin permission or database-access can read user's TROCK data. So the possibility of misuse is low.

    Bulk-anonymization

    If you are interested in anonymizing users in buik, check out my script anonymize_jira_users. I have anonymized hundreds of users so far in production, which would be quite annoying doing this user by user in the UI. But check this in a staging-instance before.

    Hope this helps,

    kind regards, Johannes

  2. outilscollaboratifs.assu@socgen.com reporter

    Hi Johannes,

    Thank you for your quick and explicit answer.

    We will take your feedback into consideration in our GDPR work.

    Kind regards,

    Roman.

  3. Log in to comment