These questions are based on basis:
WIl any one tell me where the Roles, User Names for that role, tcodes, change queues are stored.
how they interlink to each other, how can we find the single and composite roles in the table. how can we find what time it is created and when it is changed.
how can we find how much time the request in change queue....
check the following Tables
AGR_DEFINE - Role definition
AGR_USERS - Assignment of Roles to users
AGR_TEXTS - Role Descriptions
AGR_TCODES - Assignment of Roles to Tcodes
AGR_PROF - profile Name for Role
AGR_1250 - Authorization data fro activity group
AGR_1252 - Orgn elements for Authorizations
USR10 - Role Definition
UST12 - User Master Authorizations
<b>Reward points for useful Answers</b>