Assignment Of Roles To Users - AGR_USERS

If you have any request to check user roles, this table AGR_USERS will come in handy.

Table AGR_USERS data dictionary
 
AGR_NAME  CHAR  30 Role Name
UNAME CHAR 12 User Name in User Master Record
FROM_DAT DATS 8 Date of validity
TO_DAT DATS 8 Date of validity
EXCLUDE CHAR 1 Exclusive
CHANGE_DAT DATS 8 Date of menu generation
CHANGE_TIM TIMS 6  Time when the menu was generated last
CHANGE_TST DEC 15 UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
ORG_FLAG CHAR 1 Flag: Assignment Comes From HR Organization Management
COL_FLAG CHAR 1 Flag: Assignment from composite role

Normally, you can view the role in tcode SU01

Display User

Use SE16N and make used of the field AGR_USERS-UNAME to retrieve all the user roles at one go.

AGR_USERS Display

From now on, you will find that retrieving available user roles is not that difficult after all.

SAP BC Tips

See Also
Authorization Questions and Answers

Get help for your Basis problems
Do you have a SAP Basis Question?

SAP Basis Admin Books
SAP System Administration, Security, Authorization, ALE, Performance Tuning Reference Books

SAP Basis Tips
SAP BC Tips and Basis Components Discussion Forum

Administration In SAP - Sapgui, Unix, SAP ITS, Router, Client Copy and IDES 

Main Index
SAP ERP Modules, Basis, ABAP and Other IMG Stuff

All the site contents are Copyright © www.erpgreat.com and the content authors. All rights reserved.
All product names are trademarks of their respective companies.  The site www.erpgreat.com is in no way affiliated with SAP AG. 
Every effort is made to ensure the content integrity.  Information used on this site is at your own risk. 
 The content on this site may not be reproduced or redistributed without the express written permission of 
www.erpgreat.com or the content authors.