Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Hi,
I would not recommend the second method there are other tables involved and not just USR##.
Adjusting database tables is not really a good idea unless SAP have recommended it.
Your best option is to modify the instance parameter rdisp/max_wprun_time to a value of 0 (Zero) with Tx RZ11
Then use Tx SU10 and delete all 20000 user Ids then use Tx RZ11 to modify the parameter again.
Regards
| | | ---------------Original Message---------------
From: hfuquay
Sent: Sunday, June 26, 2011 11:09 PM
Subject: Mass user deletion (arround 20000 users)
You have a couple of choices. SU10 is the cleanest way, and I would suggest
if you use SU10, then do like a 1K users at a time. If you want to do them
all, then change the paramater wrun to 0, run your deletion, and then
change wrun back to the pre-deletion alue.
The second choice is at the database level. All users and their information
are stored in the USR01-USRxx tables. You can delete records out of those
tables. This is some this is the preferred method is you have solid
database skills.
Hal
Hal N. Fuquay
Senior Manager/ Senior Systems Architect
Global Business Solutions
Certified SAP BASIS Consultant
Certified SAP Technology Consultant
Certified SAP Business Intelligence Consultant
CSC Global Business Solutions
Tucson, Arizona
USA
Email: email@removed
Office: +01-520-867-8131
Cell: +01- 520-260-0287
Blackberry: email@removed |
| __.____._ Copyright © 2011 Toolbox.com and message author.
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
| |  D. Caddick
SAP Basis Top Contributor
Contributed the most posts in a group for 3 consecutive months to earn a Gold Achievement Popular White Papers
In the Spotlight  _.____.__ |
