We have added search box. Key in SAP issue keyword to search
TopBottom

Announcement: wanna exchange links? contact me at sapchatroom@gmail.com.

Re: [sap-basis] Mass user deletion (arround 20000 users)

Posted by Admin at
Share this post:
Ma.gnolia DiggIt! Del.icio.us Yahoo Furl Technorati Reddit

Posted by hfuquay (Sr. Principal)
on Jun 26 at 11:07 PM
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

---------------Original Message---------------
From: BASIS_BEGINNER
Sent: Sunday, June 26, 2011 8:15 AM
Subject: Mass user deletion (arround 20000 users)

We have around 20000 in PRD system.
After system copy and as a partof post step it takes to much time to import user master data.

I just want to know how can we delete all users?
I tried via SU10 but getting time out error.

Also deleting user manually in multiple chunks is not feasible as the entire system copy is automated.

If some one can give an idea to delete all data from relevant tables at oracle level or via CATT tool.

Thanks in advance

Regards
Javed

__.____._
Copyright © 2011 Toolbox.com and message author.

Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
Mark as helpful
View this online
  
Popular White Papers

In the Spotlight
Which response to your Toolbox.com Groups post was the most helpful? Use 'Best Answer' to mark highest quality content.
_.____.__

0 comments:

Post a Comment

T r a n s l a t e to your language