- SAP Community
- Groups
- Interest Groups
- Application Development
- Discussions
- unused user groups
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
unused user groups
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-04-2009 8:22 AM
Hi
Can anybody let me know how to find the unused usergroups.
Here we are trying to clean up the unused data, we enocountered that there are user groups are not assigned to user.
How to find out them?
- SAP Managed Tags:
- Security
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-04-2009 9:07 AM
Probably the easiest way is to go to SE16N and in the select options for field CLASS of table USR02 select each entry once and click on "Number of Entries".
Anything which returns 0 entries is not used => and delete in SUGR.
You could do the same in transaction RSUSR200, and then also add a group to any users without an assignment.
Cheers,
Julius
- SAP Managed Tags:
- Security
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-04-2009 10:03 AM
or you can download all the groups from table USGRP, and then download the user-group assignment from USR02 in an excel sheet. Then you just have to take unique user group entries (remove duplicates option in Excel 2007 is great !! ) from the USR02 dump and compare it agains the USGRP dump to find which user groups are not assigned to any users.
Cheers !!
Zaheer
- SAP Managed Tags:
- Security
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-04-2009 11:41 AM
