cancel
Showing results for 
Search instead for 
Did you mean: 

Users got deleted from USR02 - Pleas eHelp

Former Member
0 Kudos

Hi,

we did a heterogeneous system copy and we by mistake deleted the users from DB with the following command..now we are not able to login into SAP...

TRUNCATE COUNT(*) from sapsr3.usr02;

now it has been truncated to 0. is there any way we can get the original number(users) back to sapsr3.usr02 ?? original number was 156.

pls help.......

Thanks

Sourav

Accepted Solutions (0)

Answers (1)

Answers (1)

markus_doehr2
Active Contributor
0 Kudos

What you can try:

- find the R3load package with USR02 in it (search for USR02 in the .TSK files)

- set all USR02 related entries to "xeq" instead of "ok" in that TSK file

- Check the logfile of the package for the full command R3load is called

- execute the command exactly as written in the logfile

--

Markus