How to check user's role menu in exit EXIT_SAPLRRS0_001?

[Former Member]

Hello experts,

within exit EXIT_SAPLRRS0_001 I want to check if the currently executed query belongs to the sap role menu, that is assigned to the user.

If not, the query execution shall abort.

So, how can I get that information? What I need to know is the connection from: Query-->User-->Role Menu

In which tables can I search for this?

Thank you in advance.

[Former Member · Accepted solution]

HI,

you have to go to table AGR_USERS there you can find the connection between users and roles.

Check field AGR_NAME for role and UNAME for user.

The second table that you need is table AGR_HIER where you can find connection between roles and queries. You have to check only records where field REPORT = "SAP_BW_QUERY" . In field AGR_NAME is role name and in filed SAP_GUID is ID of the query.

So the all steps are:

1) check the querz GUID

2) with GUID of query go to table AGR_HIER where REPORT = "SAP_BW_QUERY" and ŚAP_GUID = GUID and check the value in filed AGR_NAME

3) With AGR_NAME go to table AGR_USERS and check corresponding records and check if you are able to find there the current user....

Hope this help,

Tomas