Mass change the Knowledge Document Permission to inherit from parent

Products

• CA Service Management - Service Desk Manager
• CA Service Desk Manager

Issue/Introduction

When creating Knowledge Documents, the permission is set to Control by Role.

Is there a way to do a mass update for all Knowledge Documents to set the permission to Inherit from Parent, in order to use a universal setting on the Category level?

Environment

Release : 17.x

Component : SDM KNOWLEDGE MANAGEMENT

Resolution

Update the table "SKELETONS" specifically the field "INHERIT_PERMISSION", this field is set to 0 when the permissions are not inherited. 

To do this, use the pdm_extract and pdm_load which will need a pdm_d_refresh or update it directly in the DB but you will need to restart the SD service, in both cases take a backup of the DB.


i.e

pdm_extract -f "SELECT id, inherit_permission FROM SKELETONS" >kd.txt (extract the required data and modify it)

pdm_load -a -f kd.txt (update the modified data)

pdm_cache_refresh -t KD (refresh the SKELETONS object)

Since the change is to set the "inherit from parent", from any of the "control by" options it should use the permissions of the parent category instead of continue using the previous settings.

Note: Test in a DEV environment before doing this in PRD and also test in a single document in order to verify the results.