Backend tables used for Knowledge Permissions Handling
Article ID: 212343
Updated On:
Products
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.
Feedback
