How to display backend role - user and role -tcode related table on GRC

[Former Member]

Hi,

I want to get Role - assinged User and Role - Tcodes on related Role tables on GRC for backend systems. How can i get that?

Kind Regards

[vandana_maini · Accepted solution]

Hello Musa,

We have below mentioned tables in GRC where Role data is stored:

1. GRACROLE: Role details: Fetch the Role ID from here
2. GRACUSERROLE: User Role Assignment Table: User Role ID to check the User assignment to the role
3. GRACROLEACT: Role Action Table: User Role ID to check the Tcodes in the role.

I hope this helps.

Regards,
Vandana

[Former Member]

Tables and values:

GRACRLCONN: ROLE_ID & ROLE_NAME

GRACROLE: ROLEID & ROLE_NAME

GRACUSERROLE: ROLE_ID & USER_ID

GRACROLEACT: ROLEID & ACTION