I would like to identify the tables that provide information on the associations between roles and policies, as well as the associations between policies, scopes, and permissions

Getting advice
1

1.) Associations between roles and policies, as well as the associations between policies, scopes, and permissions.

Need this information for fetching the user , role, scopes, policy and permission details using a single query joining the tables