Tables in Use:
Role Mapping Table: Links Role IDs to User IDs.
Role Table: Contains the mapping of Role IDs to Role Names.
Steps:
Extract User and Role IDs:
From the 'Role Mapping' table, identify the User ID and Role ID columns. These fields are critical for linking users to their roles.
Link Role Mapping to Roles:
Use the Role ID from the 'Role Mapping' table to join with the ID in the 'Role' table.
This connection will allow you to match the Role IDs with their respective Role Names.
By completing this procedure, you will have a list of users with their corresponding role names.