Skip to Content
avatar image
Former Member

Is there a table with UAR role and user details?

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Feb 19 at 06:59 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 21 at 05:06 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 22 at 05:40 AM

    Hello,

    GRACREVITEM.REVIEW_ITEM_ID = GRACROLE.ROLEID

    Kind regards,

    Yashasvi

    Add comment
    10|10000 characters needed characters exceeded