Is there a table with UAR role and user details?

[Former Member]

I'm trying to find Actions performed for each roles in UAR. I got Actions under table

GRACREVITEM. I need the role details and users assigned to each roles. Is this information maintained in any tables? if so please let me know the table names.

[former_member226273]

Hello,

GRACREVITEM.REVIEW_ITEM_ID = GRACROLE.ROLEID

Kind regards,

Yashasvi

[Former Member]

Hi Yashasvi,

Thank you for your response. I'm using SQVI to combine tables so that I get a detailed report with all roles marked for removal with the role names and the user names. I have tried all the tables you have suggested already. I could not connect the two tables GRACREVITEM and GRACROLE, I'm getting illegal join conditions. What would be the fields that would connect these two tables? Any ideas?

Appreciate your feedback.

Thanks,

Rasi

[former_member226273]

Hello,

Role details:

Take Review_item_id from table GRACREVITEM and you can get role details fro GRACROLE table.

User Assignments:

For technical roles:

Take role name from here and put in GRACRLCONN, take ROLE_ID from here and put in GRACUSERROLE to get user assignments.

In case of Business roles,

Take ROLEID from GRACROLE and put in table GRACUSERROLE (BUS_ROLEID) to get user assignments.

Please let us know in case of questions.

Kind regards,

Yashasvi