SQL statements: Right to erasure

Individuals have the right to ask our organization to delete any personal information about them that our organization holds. The following table lists personal data stored in WebSphere Commerce and shows how to delete the data using an SQL query.

Type of personal data SQL query and database table
Address 

    DELETE FROM ADDRESS WHERE MEMBER_ID=?;

Birth date 

    DELETE FROM USERDEMO WHERE USERS_ID = ?;

Browsing Behavior 

    DELETE FROM DMUSERBHVR WHERE DMUSERBHVR.PERSONALIZATIONID IN (?PERSONALIZATIONID?)

Challenge answer 

    DELETE FROM USERREG WHERE USERS_ID = ?;

Currency 

    DELETE FROM USERS WHERE USERS_ID = ?;

Demographics 

    DELETE FROM USERDEMO WHERE USERS_ID = ?;

Email Address or IBMid 

    DELETE FROM ADDRESS WHERE MEMBER_ID=?;

Gender 

    DELETE FROM USERDEMO WHERE USERS_ID = ?;

Income 

    DELETE FROM USERDEMO WHERE USERS_ID = ?;

Language 

    DELETE FROM USERS WHERE USERS_ID = ?;

Logon ID 

    DELETE FROM USERREG WHERE USERS_ID = ?;

Name 

    DELETE FROM ADDRESS WHERE MEMBER_ID=?;

Order History 

    DELETE FROM ORDERS WHERE MEMBER_ID =?;

Password (for shoppers and CSRs) 

    DELETE FROM USERREG WHERE USERS_ID = ?;

Phone Number 

    DELETE FROM ADDRESS WHERE MEMBER_ID=?;

Referral URL 

    DELETE FROM DMUSERBHVR WHERE DMUSERBHVR.PERSONALIZATIONID IN (?PERSONALIZATIONID?)

Search History 

    DELETE FROM DMUSERBHVR WHERE DMUSERBHVR.PERSONALIZATIONID IN (?PERSONALIZATIONID?)


Related concepts
General Data Protection Regulation (GDPR) and WebSphere Commerce