# 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

**URL:** <https://forum.keycloak.org/t/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/28523>\
**Category:** Getting advice\
**Created:** [October 30, 2024, 5:05am UTC](https://forum.keycloak.org/t/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/28523 "2024-10-30T05:05:35Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Shubhankarsen95](https://avatars.discourse-cdn.com/v4/letter/s/a183cd/32.png) [@Shubhankarsen95](https://forum.keycloak.org/u/Shubhankarsen95)\
**Post date:** [October 30, 2024, 5:05am UTC](https://forum.keycloak.org/t/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/28523/1 "2024-10-30T05:05:35Z")

</div>

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