When knowledge administrator tries to modify the knowledge category permissions to role based and gets into some errors like Error 1 attempting to
set READ_GROUP_LIST to "10016,400003": AHD04507:Trigger Error, they would like know the mdb tables that store the these info in order to trouble shoot the problem. Sometime the data integrity issue is the reason the error occurs and in that case, DBA would need to perform data clear-up.
What mdb tables store info for new Knowledge Category with role based permissions?
Service Desk/CMDB 12.9, 14.1, 17.1 on Windows/Linux/Unix
The info are stored in two mdb tables: usp_role_pgroup and P_GROUPS with this schema in usp_role_pgroup
pgroup SREL -> P_GROUPS.id TENANCY_UNRESTRICTED
This means, for every entry in P_GROUPS table, there should be an entry in usp_role_pgroup table and vice verse. If this is not true,
errors like "Error 1 attempting to set READ_GROUP_LIST to "10016,400003": AHD04507:Trigger Error" will occur when knowledge administrator
performs knowledge category role permission changes.