How to reset user SAP*

To reset password of user SAP in ABAP stack on client 000, use this strategy:

We need to delete user ID SAP* in Client '000' at SQL level

For MS-SQL, you will use the SQL Management Stuido and run a Query.
Use the following SQL:
Delete from .USR02 where MANDT='000' and BNAME='SAP*'

For Oracle:
sqlplus "/ as sysdba"
Delete from .USR02 where MANDT='000' and BNAME='SAP*';

is one of these entries:

if system was originally installed with SAP Basis 4.x or below: SAPR3
if originally installed with SAP Basis 6.x (That is ERP 5): SAP[SID]
If originally installed with SAP Basis 7.x (That is ERP 6): SAPSR3


You then need to change the instance parameter:
'login/no_automatic_user_sapstar = 0' (Zero) and restart the system. You can then logon to client '000' with User SAP* and password 'PASS'.
You then create your user ID in client '000' and Recreate SAP* then change the instance parameter 'login/no_automatic_user_sapstar = 1' and restart the system.


If you want to change SAP* in clients other than 000, simply use the same procedure and adapt client number accordingly.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/445851/viewspace-613032/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/445851/viewspace-613032/