table name to find out roles assigned to USER !!
Hi BW Gurus,
i want to find out all the roles assigned to users , i check in tables USR01, USR02 , USR21, and ADRP ...... i got first name , last name , account number . BUT I NEED ROLES . can anyone kindly help me ,since otherwise i have to copy paste all manaully which takes more time...
100% points are assingned
Check in this tables:
AGR_USERS - Assignment of roles to users
AGR_USERT - Assignment of roles to users
AGR_PROF - Profile name for role
AGR_AGRS - Roles in composite roles
Assign points if this helps