Procedure

Platform stores the name, title, department, company, address, phone numbers, email address, locale, and time zone of users.

  • To view and extract a user's personal information, the Unica Platform Administrator should log on to Unica Platform, go to the user's page and do a screen-shot.
  • To remove personal information, through the User Interface, the Platform Administrator should log on to Platform, go to the user's page, remove personal information, and save.
  • To remove personal information, through SQL scripts:
    1. Stop the Platform web application, take backup of the DB.
    2. Replace the UserLogin with the value of the user's login in the following queries and run them against the Platform DB schema.

      To delete User Preferences:

      DELETE FROM usm_personalization
      WHERE user_id IN (SELECT ID FROM usm_user WHERE name='UserLogin')

      To delete the user’s personal information:

      UPDATE USM_USER
      SET FIRST_NAME='', LAST_NAME='', DEPARTMENT='', ORGANIZATION='',
       COUNTRY='', EMAIL='', ADDRESS1='', ADDRESS2='', 
      PHONE1='', PHONE2='', PHONE3='' WHERE NAME='UserLogin'

      Note: Manually key in the script; do not copy-paste it.

    3. Restart the Platform web application.