Tables in MS SQL server where role names are stored

[Former Member]

hi

Please let me know the table in MS SQL server where the authorisations and role names are stored

[Former Member]

Hi,

Table agr_define stores the roles.

Some more tables in this regard are as under

AGR_AGRS Roles in Composite Roles

AGR_PROF Profile name for role

AGR_SELECT Assignment of roles to Tcodes

AGR_TCDTXT Assignment of roles to Tcodes

AGR_TCODE3 Assignment of roles to Tcodes

AGR_TCODES Assignment of roles to Tcodes

AGR_USERS Assignment of roles to users

AGR_USERT Assignment of roles to users

etc etc.

To explore more in Tcode SE11 enter AGR* and search.

Table USOBT details reln between tcode and auth object.

Hope this helps

Pl dont forget to award points.

Regards

[Former Member]

hi, My instance name is ABC. Please let me know whether the tables are present in this database or MASTER database

[Former Member]

also let me know the table or query where i can get the authorisation and the corresponding role

[Former Member]

Hi,

Actually the Tcode for which authorization are granted ie Roles vis.a.vis tcode are imaintained in table TSTCT.

Tcodes and authorization objects are listed in table USOBT.

This can help you to generate the querry.

Regards

[Former Member]

Please let me know the table where i can see all the authorisations in the System irrelevent of Tcode

Message was edited by:

Balaji Rajendran