Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Reverted from v. 2

...

To remove users and their personal information from Zephyr, the administrator managing the users must first disable the users before prior to deleting them the user. The administrator deleting the user also needs access to the database storing the user information for Zephyr. Follow the below steps to remove any existing personal information/details of a user for the following databases:

...

2. Run the following update and add/replace the IDs ids of the user as the parameters for 2nd query to update the information.

...

2. Run the following update and add/replace the IDs ids of the user as the parameters for 2nd query to update the information.

...

2. Run the following update and add/replace the IDs ids of the user as the parameters for 2nd query to update the information.

...

Code Block
update users set first_name=CONCAT('deleted.user',id), last_name=CONCAT('deleted.user',id), username=CONCAT(CONCAT('deleted.user',id),'.',CONCAT('deleted.user',id)), email=null, title=null, address1=null, address2=null, city=null, user_state=null, country=null, postal_code=null, loc=null, work_phone_number=null, mobile_phone_number=null, home_phone_number=null, website=null, picture=null, password_hint=null, status=null, login_name=CONCAT(CONCAT('deleted.user',id),'.',CONCAT('deleted.user',id)) where id in (<id comma separated if multiple ids>);

Delete Inactive User's

For our customers' GDPR compliance, we now provide a method to completely delete inactive users with all PII (Personally Identifiable Information) from the database, that user will be assigned as an In-active deleted user

...

  • Once users enable this Flag, they will see a button Delete Inactive Users in
    Administration > Customizations > Advanced > Delete Inactive Users

Image Removed

  • Click on the button Delete Inactive Users a Pop-up will come.

Image Removed

In the above pop-up

Total number of users to be deleted at a time:-

  • The value that at a time the number of users will be deleted. This can be configured in the Properties file in {ZephyrDIR}/tomcat/webapps/flex/WEB-INF/classes/gdpr.properties.

  • By default, the value is one

  • It can be configured by changing the value of zephyr.gdpr.delete.count
    #zephyr gdpr delete count
    zephyr.gdpr.delete.count=1

  • Once this value is changed System needs to be restarted to make the change value effective

Total number of inactive users

  • This is the total number of inactive users present in the system.

  • Once click on the Delete button users will start getting deleted one by one depending on how many users are to be deleted at a time depending on the value in the Total number of users to be deleted at a time.

Image Removed

Note

This action is irreversible make sure you want to delete the user as it will remove the complete trace of the User from the system.

Once Users are deleted, they will get replaced by the User called “InActive user”.

...