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

Article Id: 131201

Status: Published

Updated On: 23-04-2019 04:40

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.