Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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


Former Member
Former Member replied


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


Jorge Diogo

0 View this answer in context

Helpful Answer

Not what you were looking for? View more on this topic or Ask a question