08-17-2009 10:27 AM
Hi
Is there any database table which could give transaction codes attached to composite roles in SAP Security?
AGRS_1251 table gives tcodes for singl roles only under a composite role.
Thanks
08-17-2009 10:32 AM
08-17-2009 10:39 AM
HI,
Check these tables
agr_agrs,
agr_define,
Regards,
Nagaraj
08-17-2009 10:41 AM
Hello ,
AGRS_1251 table gives tcodes for singl roles only under a composite role
If you are talking about AGR_1251 i think it stores the Auth. Object details for the Single Role & not the t-code details. Correct me if i am wrong.
I think you can have a look @ AGR_TCODES.
BR,
Suhas
08-17-2009 10:45 AM
hii,
Using Tcode PFCG you can assign role or more multiple users in one attempt.
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_TCDTXT Assignment of roles to Tcodes
AGR_TCODE3 Assignment of roles to Tcodes
AGR_TCODES Assignment of roles to Tcodes
AGR_SELECT 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
regards,
Shweta