Difference between revisions of "General Data Protection Regulation (GDPR) (EU)"
From Diversity Workbench
(→Changes to be implemented in the databases) |
|||
| Line 5: | Line 5: | ||
** New columns: | ** New columns: | ||
*** ID: ID replacing the login name in datatables e.g. in columns LogUpdatedBy etc. | *** 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 | + | *** 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 | + | *** 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]] | Back to [[Software#Diversity_Workbench_software_implementations_in_compliance_with_regulations_and_directives]] | ||
Revision as of 12:49, 9 April 2018
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)
- New columns:
- 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
