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

How to do SAP R/3 Security configuration, design, development, testing, implementation and production support.

2235


the company needs to expand its region to another country which the same authorizations had previously what approach you will take

1643


What are the different types of sap security tables?

669


In Agr_1251 we are able to see 100 roles but in SUIM we are able to see 120 roles what's the reason behind this ? why is the difference between the SUIM and the AGR table ?

547


You wan to transport user groups from transaction sugr? Would this impact the groups tab in su01? What would you do?

734






what is the difference between usobt_c and usobx_c?

775


Differentiate between usobx_c and usobt_c

628


how we Set up Central User Administration (CUA) to manage 4 systems/clients

1822


Please also send me details about CRM 5 and CRM 7 security issues and scenarios.

2219


how we Custom Authorization Objects and Custom Transaction maintenance and how we do User classification, Running systems measurement reports during license auditing through USMM and SLAW

1872


what is your ticketing tool? can we give some details about how we are getting tickets

1159


what things you have to take care before executing run system trace?

747


What is the difference between authorization object and authorization object class?

650


what is the different b/w su10 and su12

2184


What appears as the last sentence in sap note 587410?

662