SAP* user w/o authorization

[Former Member]

Hi all,

After creating a new client with TCode SCC4, e.g: 200, I logon this new client using sap/pass. Next, I create a new user: sap w/o authorization by accident. Now I have no user with admin authorization to work with this client: customize the client, delete client, ...

Anyone knows how to deal with this client status? how to delete it to recreate the client if no right to work with the client?

Thanks,

Toan Do

[former_member185954 · Accepted solution]

Hi Toan,

You can delete the SAP* userid from database level, here is what you should do.

Login into the SAP database and run this query.

1. schema-id = SAPR3 or SAP<SID> depending on your SAP Release

2. client = 200 in your case

You may want to be sure what you are deleting , so check what you are deleting with the following query.

select bname,mandt from <schema-id>.USR02 where bname='SAP*' and mandt='<client>';

delete from <schemaid>.USR02 where bname='SAP*' and mandt='<client>';

commit;

Hope that helps.

Regards,

Siddhesh

[Former Member · Accepted solution]

Yes Siddhesh,

I find out a doc and it says to delete the related record in table USR02 - as you suggest.

Thanks,

Toan Do