usp_roles rows were modified in the entire table at the same time

book

Article ID: 131201

calendar_today

Updated On:

Products

SUPPORT AUTOMATION- SERVER CA Service Desk Manager - Unified Self Service KNOWLEDGE TOOLS CA Service Management - Asset Portfolio Management CA Service Management - Service Desk Manager

Issue/Introduction

usp_roles rows were modified in the entire table at the same time by the same user. Customer wants to know how this was modified

Cause

It was possibly modified through a pdm_load lauched by anyone.

Environment

Service Desk Manager 17

Resolution

We could see that the usp_role table has all last modified date and modified by columns with exact the same date and the same user.
We don't have any evidence in the stdlogs about this changes and also we cannot know how exactly this was done, however, this type of modification would only be possible through a pdm_extract / pdm_load, dur the the way that was done.
The only way to prevent this is to restrict the access to these users.