1. Transparent tables
AGR_1250: Authorization data for the activity group
AGR_1251: Authorization data for the activity group
AGR_TCODES: Assignment of roles to Tcodes
UST04 : User masters
USOBX : Check table for table USOBT
2. The fields of these tables
AGR_1250: agr_name -> role name, object -> Auth. object in user master maintenance
Auth -> Authorization name in user master maintenance
AGR_1251: agr_name -> role name, object -> Auth. object in user master maintenance
field -> field name of an authorization
auth -> Authorization name in user master maintenance
AGR_TCODES: agr_name -> Role name, TCODE -> Extended program name
UST04: bname -> User name in user master record,
profile -> Profile name
3. How to list all transactions in one role?
SELECT AGR_NAME
FROM AGR_TCODES
WHERE TCODE='ME22'
4. How to find a transaction code is assign to which user?
SELECT bname
FROM ust04
WHERE profile IN
( SELECT DISTINCT substr(p.auth,1, 10)
FROM agr_1250 p, agr_tcodes t
WHERE p.agr_name = t.agr_name
AND t.tcode = 'ME22')
SELECT bname
FROM ust04
WHERE profile IN(SELECT p.profile
FROM agr_PROF p, agr_tcodes t
WHERE p.agr_name = t.agr_name
AND t.tcode = 'ME22')
5. How to list a role is assign to which user?
SELECT bname
FROM ust04
WHERE profile IN
( SELECT DISTINCT substr(p.auth,1, 10)
FROM agr_1250
WHERE p.agr_name = 'Z:DGSSL')