how to set sap* password default

[Former Member]

hi frzs

i am using 4.7 ides version and just want to know that the default password of sap* is 06071992 in 000 client but sombody had change it is there any abap report or program which set default password of default user like sap* and ddic .

If there is any kind of process then tell me .

thanks in advance.

[Former Member]

Hi Anuj,

You can logon as DDIC and change the SAP* password

or

1. Log on to oracle database using sqlplus.

sqlplus / nolog

SQL>connect /as sysdba

SQL>update <SchemaOwner>.USR01 set bname='SAP1' where bname='SAP' and MANDT=000;

1. [ e.g.: update SAPR3.USR01 set bname='SAP1' where bname='SAP' and MANDT=000; ]

2. [e.g. : update SAP<SID>.USR01 set bname='SAP1' where bname='SAP' and MANDT=000;]

SQL>commit;

SQL>exit

Hope it helps.

Cheers

Deepanshu

[Former Member]

Login to the Client 000 with DDIC/or any Admin User and reset in SU01.

or

If your DB is Oracle :

login as orasid

- sqlplus '/as sysdba'

- delete from <schema>.usr02 where bname = 'SAP*' and mandt =000

- restart the server

- Login to 000 with SAP* and password 'PASS'

- Reset the password in SU01

[Former Member]

delete from <schema>.usr02 where bname = 'SAP*' and mandt =000

please mention that what should i write in<schema>please if you can write whole query.

thank you sir

[Former Member]

Schema is the database owner, In SAP screen choose System ->Status, there you will find the Database owner. (default is SAPR3 or SAPSR3).

set "login/no_automatic_user_sapstar = 0" in your instance profile

[Former Member]

hi have u checked with su01 & tried to reset the password.

Rahul