WebSphere Commerce Version 8.0.4.12

SQL statements: Right to erasure

Individuals have the right to ask your organization to delete any personal information about them that your organization holds. The following table lists personal data that is stored in WebSphere Commerce and shows how to delete the data by 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?)