[koletas]

QL> select bname,uflag from sapsr3.usr02 where mandt='000' and bname='SAP*';

BNAME UFLAG
------------------------------------ ----------
SAP* 128

SQL> update sapsr3.usr02 set uflag=0 where mandt='000' and bname='SAP*';

1 row updated.

SQL> commit;

Commit complete.


SQL> select bname,uflag from sapsr3.usr02 where mandt='000' and bname='SAP*';

BNAME UFLAG
------------------------------------ ----------
SAP* 0


SQL> delete from sapsr3.usr02
2 where mandt='000'
3 and bname='SAP*';

1 row deleted.

SQL> commit;

Commit complete.


A nivel de SAP desde cualquier mandante poner a '0' el siguiente parámetro y reiniciar SAP para entrar como SAP*/PASS. Desbloquear
el usuario SAP* o DDIC, o el que sea y volver a poner el parámetro a '1'. Reiniciar de nuevo SAP.
Note 68048 - Deactivating the automatic SAP* user
login/no_automatic_user_sapstar=0 dentro del perfil de instancia y reiniciar SAP y entrar como SAP*/PASS.


SAP envió esto una vez:
Resetear password SAP* o DDIC


25.04.2007 - 16:41:22 CET SAP Respuesta
Dear Customer,

Yes, you can reset the user SAP* by deleting him from USR02 directly in
ORACLE at DB level with:

DELETE FROM USR02 WHERE MANDT='<client>' AND BNAME='SAP*' ;


Further steps:

o Check whether the SAP* emergency user is active (see Note 68048)

o For systems as of Release 6.10 (WebAS) it is necessary to restart the application server due to the buffering of the USR02 table.
This ensures that the table entry is deleted effectively by using the database utilities.

You can now log on to the system again with the SAP* user and the
initial password 'PASS'