correct table/field concerning roles per user id in SU01

[Former Member]

Currently we are implementing GRC Access Controls 10.0. We need to do some custom development, especially in SU01. I therefore need the correct (transparant) table and field per user id concerning the roles that are connected to a user. For many screen fields the correct tables can be, sometimes easily, found, but this one is really hard.

In which table gets the role information per user id stored? Data element and field are agr_name and normally the tables corresponding to the user id are named USR*.

Thank you for your help.

[Former Member · Accepted solution]

Hi,

Please try with SUIM transaction or AGR_USERS table. This table will give you the roles assigned to users.

Thanks,

Regards,

Ignacio Barrionuevo