There are situations when the SAP*,DDIC and all the other users are locked and there is no possibitly to login to the R3 System.
If you are stuck up in such a situation, then this document will be your rescure 
1. Login to the Operating System.
2. Login to the database using sqlplus / as sysdba;
3. Execute the Query Delete from <schema_name>.usr02 where bname = 'SAP*' and client = '000';
This will reset the password of sap* to pass
Once the password for SAP* is reset, the other users can be unlocked.
If the procedure doesn't work, then,
The parameter login/no_automatic_user_sapstar would be set to 1.
You will have to include this line login/no_automatic_user_sapstar=0 in your default and the instance profile.
Restart your system and then retry.
More about the parameter logon/no_automatic_user_sapstar:
If the user master record belonging to user SAP* is deleted, it is possible to re-log on with SAP* and initial password PASS.
SAP* then has the following attributes:
1. The user has all authorization, as authorization checks cannot be executed.
2. You cannot change the standard password PASS.
3. Using profile parameter login/no_automatic_user_sapstar, you can deactivate the special attributes of SAP*.
1. The user has all authorization, as authorization checks cannot be executed.
2. You cannot change the standard password PASS.
3. Using profile parameter login/no_automatic_user_sapstar, you can deactivate the special attributes of SAP*.
Values
0: Automatic user SAP* is permitted
1: Automatic user SAP* is deactivated
1: Automatic user SAP* is deactivated
No comments:
Post a Comment