How to find the relation between role and user, t-code, profile

 

1. Transparent tables
o3X$d'I u'ge z"az4E13316   AGR_1250: Authorization data for the activity groupITPUB个人空间N8zj&U?�yl
   AGR_1251: Authorization data for the activity group
,? Dv�AABMS-G$B
F13316   AGR_TCODES: Assignment of roles to Tcodes
w3I!zBHl*l13316   UST04     : User mastersITPUB个人空间v1N"](MK9sU2zZ/Y
   USOBX     : Check table for table USOBTITPUB个人空间D:Z~;{6n'd
  
5s
jy4E'/CL0F^133162. The fields of these tables
za%Of}~,D$F13316   AGR_1250: agr_name -> role name, object -> Auth. object in user master maintenance
$D,k7mF�s7K13316             Auth -> Authorization name in user master maintenanceITPUB个人空间{}@n/$H4Qa
   AGR_1251: agr_name -> role name, object -> Auth. object in user master maintenanceITPUB个人空间]zh3[m
             field -> field name of an authorization
y6@Q:Y4jw-m3i13316             auth -> Authorization name in user master maintenance
,u;{Goz13316   AGR_TCODES: agr_name -> Role name, TCODE -> Extended program name
(V1}1j|C Tr|13316   UST04:      bname -> User name in user master record,
4X)Ll_/13316               profile -> Profile name

3. How to list all transactions in one role?
r!h*K`7n%d5m&Wp13316 SELECT AGR_NAMEITPUB个人空间di7qh'P1{G5E
 FROM   AGR_TCODES
"CqJG z4X,MO!y13316 WHERE  TCODE='ME22'

4.  How to find a transaction code is assign to which user?ITPUB个人空间/Z%|Gn-`x
SELECT bname
@}9x;{cWMk13316FROM     ust04
"a]X:p`)|13316WHERE  profile  INITPUB个人空间bSI9C/t2B0y'Z
                ( SELECT  DISTINCT substr(p.auth,1, 10)ITPUB个人空间3z.A3P@I3]n
                  FROM   agr_1250 p, agr_tcodes t
XF"K$o7E!s|Z$M-A`13316                  WHERE  p.agr_name = t.agr_nameITPUB个人空间sh$d6]])`6o
                  AND   t.tcode = 'ME22')
0vyp8N-zF*tnP'yc13316       

SELECT bnameITPUB个人空间rd)]3a|#nI+f
FROM     ust04ITPUB个人空间-_ /q5KeY
WHERE  profile  IN(SELECT p.profile
-fI'n+@zo13316 FROM   agr_PROF p, agr_tcodes t
^n"Y9mO7`�`13316WHERE  p.agr_name = t.agr_nameITPUB个人空间A$_1^
lm2T1A
 AND   t.tcode = 'ME22')

ITPUB个人空间W~+h5[r6d$E
5. How to list a role is assign to which user?
/UM0tDU13316SELECT bnameITPUB个人空间W,gf|#P!uQ,q
FROM   ust04
Fr:Hds
Y5z!x:n(x13316WHERE  profile  IN
/U.E@'Pz/f"r'[y)O13316                ( SELECT  DISTINCT substr(p.auth,1, 10)
1AJzfyk13316                  FROM   agr_1250ITPUB个人空间T;D0R8gH'Jc8j
                  WHERE  p.agr_name = 'Z:DGSSL')