How can I find List of users in system who dont have any
role assigned (Role Tab Blank) but created in system ?

Answer Posted / sudha

Take the Two tables Usr02 and AGR_USERS.
USR02 contains all the users information
AGR_USERS contains the users who has roles attached to their
profile.

Filter the data of these two tables then you will get the
list of the user who don't have any roles assigned

Is This Answer Correct ?    9 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Please let me know if there any vacancies for 3 years of Experienced level in SAP Security

941


What does the account assessment category specify in a purchasing order in SAP Materials Management?

1095


what is the main difference between the derived role and a single role?

776


What is sap internet transaction server?

790


How to update risk id in rule set?

751






What is the difference between usobx_c and usobt_c?

719


Can you explain transport system-level security?

709


What is stad?

816


How can I do a mass delete of the roles without deleting the new roles?

968


Attributes in SE01?

2214


What is Sap security t-codes?

817


Can you explain sap system transactions?

763


As a SAP security consultant what is the most challenged you faced in previous company?

759


what is use of copy data in derived role and when we use this one ???

1421


What are se09 t-codes used for?

788