what Database table stores the Role Category information

Summary:

need to fetch data describing that which user has what roles and its categories.

we have used below tables for our custom query

per_user_roles

per_users ,

per_roles_dn_tl

per_roles_dn

but we could not find Role category in any of the tables

Content (required):

Table name where user Role category is storred

Version (include the version you are using, if applicable):

11.13.23.04.0

Code Snippet (add any code snippets that support your topic, if applicable):

SELECT pu.user_id,

     pu.username,

     ppnf.full_name,

     prdt.role_id,

     prdt.role_name,

     prd.role_common_name,

     prdt.description,