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
What is the main purpose of parameters, groups & personalization tabs?
How can I do a mass delete of the roles without deleting the new roles?
Explain snc in sap security?
what are the pre-requisites that should be taken before assigning sap_all to a user even there is an approval from authorization controllers?
Can you explain transport system-level security?
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 ?
What is the Functionality difference between ECC 5 and ECC6? i.e. new functionality in ECC6 which is not in ECC 5.
How do you check background jobs?
how we Restrict the auth groups for table maintain, creating Auth group using SE54 to built new Auth groups to restrict tables via auth object S_TABU_DIS
How to run the daily background job s for virsa violations ? thabks in advance
When would you update a sap table directly? What precautions would you taje?
what is authorization object and authorization object class?
What is stad?
Explain internet-level security?
What appears as the last sentence in sap note 587410? What does it men and how would you restrict it?