General Data Protection Regulation (GDPR) (EU)

see https://en.wikipedia.org/wiki/General_Data_Protection_Regulation

Changes to be implemented in the databases

• Table UserProxy:
  • New columns:
    • ID: ID replacing the login name in datatables e.g. in columns LogUpdatedBy etc.
    • PrivacyConsent: If the user constented to the storage and processing of his data in the database (set by user during login)
    • PrivacyConsentDate: The time and date of the consent (set via trigger)
• Function UserID(): Providing the ID of the user in replacement of the SQL function User_Name() etc.
• Datatables
  • Insert missing content from columns LogUpdatedBy into UserProxy
  • Changing the contstraints for the logging columns from suser_sname() to UserID()
  • Changing content of logging columns from name to ID

---

Back to Software#Diversity_Workbench_software_implementations_in_compliance_with_regulations_and_directives