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

Which transaction code is used to display the user buffer?

1142


what is authorization object and authorization object class?

1195


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 ?

1019


What are the different types of sap security tables?

1056


Support types of WOs you have faced?

2246


What is the maximum number of profiles in a role and maximum number of object in a role?

974


How to update risk id in rule set?

1089


What are se10 t-codes used for?

1071


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

1383


Can you explain network topology in sap systems?

1055


How we Educated client personnel in R/3 Security and general Basis knowledge

2216


explain the personalization tab within a role?

1318


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

1330


What are st01 t-codes used for?

1110


HI FRIENDS... I WANT TO KNOW FEW TICKETS ON SECURITY WITH SOLUTION.

1921