05-02-2007 7:32 PM
Experts,
I have the user DDIC password locked.Could anyone help me recover the password from the SQL database.
05-02-2007 9:17 PM
Muthyal,
Generally speaking you cannot recover the password as only the hashed password value is stored. You should reset the password and unlock the ID.
Cheers,
Ben
05-03-2007 3:22 AM
05-03-2007 6:04 AM
Hi Satish,
User DDIC can be unlocked using any user who has administration privelages(example: SAP*) using SU01.
Infact as benjamin said you cannot recover the encrypted password from SQL database, the only alternative is unlock and reset the password.
there is one situation where in you have to use a SQL query, that is when u create a new client and SAP* User get locked , since you have no other user to unlock it(assuming you are logging in for the first time and got SAP* locked)
SQL Query is as follows :
delete from <i>HOSTNAME</i>.NBW.nbw.USR02 where BNAME='SAP*' and MANDT='000'
This is possible because the SAP* user is hardcored to kernel , when you delete this user from database, SAP automatically gets this user from the kernel.
Please let me know if this information met your requirements and also award points accordingly.
Regards,
Raju
06-14-2007 1:49 PM
i also have same problem
but it is not working ....
what is NBW.nbw ?
iam using IDES ECC 6
-- Lee Green
06-14-2007 2:04 PM
05-03-2007 1:31 PM
Hi
Login system user SAP* and enter T Code Su01and unlock user DDIC.or Change passward if you want change passward
Awards point if help full
Thanks
Pankaj Kumar