Backend tables used for Knowledge Permissions Handling

book

Article ID: 212343

calendar_today

Updated On:

Products

CA Service Management - Service Desk Manager CA Service Desk Manager KNOWLEDGE TOOLS

Issue/Introduction

Which database tables stores the kb articles/categories and their permissions

Environment

Release : 17.3

Component : CA Service Desk Manager

Resolution

The primary table that could be examined for defined permissions are the P_Groups Table.  In this table, the GRP_LIST field contains a list of all roles or groups assigned to the given permission group.  

The table that defines the categories is the O_INDEXES table.  In this table, fields READ_PGROUP and WRITE_PGROUP tie back to the P_Groups id field to determine permissions based on category.

The table that defines the knowledge articles themselves is the SKELETONS table.  In this table, fields READ_PGROUP and WRITE_PGROUP tie back to the P_Groups id field to determine permissions on specific KB's.  In addition, field primary_index, tying back to the id field for O_INDEXES table defines the category that the document belongs to

 

Additional Information

The above information is being provided for informational purposes only.  Mass updates to the backend knowledge doc's permissions is not supported.  We would suggest if you do insist on performing such activity to have a full backup of your database prior to making any changes in the event you need to revert back the changes.