Role name in GRACUSERPRMVL

[Monsores]

Hello.

Does anyone know how can I find the role name from GRACUSERPRMVL? I tried to search for it based on GRACUSERPRMVL->ROLEID into GRACROLE->ROLEID and GRACRLCONN->ROLE_ID, but got no success.

Thank you.

[Former Member · Accepted solution]

Hi Marcelo,

Table GRACUSERPRMVL is 'User Permission Violation Table', so only those roles will come whose associated user is having permission violation. It may be possible that you are searching for that role id whose associated user is not having any permission violation. So, make sure that its user should have permission violation.

If you want to search Role Name for a particular role id then you can use table GRACROLE and extend the list width to 750 or so, you will be able to view the role name for role ids.

Regards,

Shaily

[Monsores · Accepted solution]

Hello Shaily.

Thank you for your attention, but I found the answer this morning.

I couldn't find ROLEID's from GRACUSERPRMVL neither in GRACROLE nor in GRACRLCONN, but I used ST01 to do a SQL Trace and discovered that this column (GRACUSERPRMVL.ROLEID) is directly related to the column ID on table GRACEXTOBJ. This table has another column called OBJECTID which is filled with the role name (which I was trying to take from GRACROLE.ROLE_NAME).

Regards,

Marcelo