on 11-20-2007 11:35 AM
Dear all,
I need to delete a client (scc5), but i have no login credetials to tat client or even OS leve access..Is tere any way to do it frm other clent without resetting sap* of that cleint, means any report that can be run in other clients to reset the pwd or some thing like that
Regards
Umesh K
Umesh,
Reseting sap* by deleting the entry in the table is not a clean solution.
The proper way to delete a SAP client is to log into the client you wish to delete (double check it is really the client you want to delete), then call transaction SCC5 and delete client (check "on" the "Delete Entry from T000" checkbox to also remove the client from the list of clients in transaction SCC4)
you can monitor with transaction SCC3
Please note that you will recover database space after Reorganizing the database.
However, if you do not have access to a client you wish to delete (avoid this on a regulated system or on QA, PRD systems), you can delete the client at the OS level with the tp command.
As an example, to delete client 100, you have to create a command file "delete100" with the following entries:
<i>Clientremove
Client = 100
Select * </i>
Place the command file in the /usr/sap/trans/bin directory
$ cd /usr/sap/trans/bin
$ R3trans w <log file name> -u 1 <command file name >
in this case: $ R3trans -w delete100.log -u 1 delete100
To monitor, run in a different telnet session: $ tail -f delete100
This is also documented in SAP note 13391
Let me know if you need more details.
Best regards
Frank Markarian
f.markarian@sap.com
SAP America
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
you can do this through an ABAP program if you know the SAP* password from another client:
1. access a client you know a password or change it
2. Tcode SE30
3. Open tips and tricks
4. select any tip
press the "open Code" icon
Change the code to
Code:
Tables: USR02.
Select * from usr02 where bname = 'SAP*'.
usr02-mandt = '000'.
Modify usr02 client specified.
return one screen and execute the tip and trick
THe password and user settings are now the same as the client you are logged on to.
You need to logon to the client to delete it.
If you have abap permissions you could create a report that would delete SAP* from the other client.
--
Markus
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.