Skip to Content
0

Is there a table with UAR role and user details?

Feb 16 at 09:29 PM

51

avatar image
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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Yashasvi Sanvaliya Feb 19 at 06:59 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Feb 21 at 05:06 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Yashasvi Sanvaliya Feb 22 at 05:40 AM
0

Hello,

GRACREVITEM.REVIEW_ITEM_ID = GRACROLE.ROLEID

Kind regards,

Yashasvi

Share
10 |10000 characters needed characters left characters exceeded