Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

What is the main purpose of parameters, groups & personalization tabs?

1117


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

1454


Explain snc in sap security?

1188


what are the pre-requisites that should be taken before assigning sap_all to a user even there is an approval from authorization controllers?

1072


Can you explain transport system-level security?

1240


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 ?

1065


What is the Functionality difference between ECC 5 and ECC6? i.e. new functionality in ECC6 which is not in ECC 5.

4455


How do you check background jobs?

1185


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

2151


How to run the daily background job s for virsa violations ? thabks in advance

3654


When would you update a sap table directly? What precautions would you taje?

1213


what is authorization object and authorization object class?

1262


What is stad?

1166


Explain internet-level security?

1134


What appears as the last sentence in sap note 587410? What does it men and how would you restrict it?

1048