topic Re: Forgot password in Application Development and Automation Discussions

Forgot password

Former Member — Fri, 20 Jul 2007 04:00:12 GMT

Hi,

I have SAP R/3 4.7 installed. I forgot the password.

Pls. let me know how to login without password or reset the login.

Thanks.

Points will be rewarded.

Re: Forgot password

Former Member — Fri, 20 Jul 2007 04:55:23 GMT

Hello,

Check this.

You can delete sap*

Go to cmd prompt.

Sqlplus /nolog

conn /as sysdba

sqlplus>DELETE SAPSR3.USR02 WHERE MANDT='CLIENT.NO' and BNAME=SAP*;

after doing this restart the system. So, that a new user with the name "sap" gets generated with password "pass". Provided the parameter is set login/no_automatic_user_sapstar= 0 (Automatic user SAP is permitted).

Below is the query for resetting the flag

UPDATE prd.USR02 set UFLAG = '00' where MANDT =

'000' and bname= 'DDIC';

Here prd is the database name; UFLAG is the field which we need to set to 0, MANDT represents in which client the login belongs to and BNAME is the field which contains logins. If you want to reset the flag for SAP* when it gets locked then replace DDIC with SAP* in above query.

This has answered many times !!

Note: Points always encourage me to reply !!

Re: Forgot password

Former Member — Fri, 20 Jul 2007 06:25:24 GMT

Hi ,

If all the users are locked, they can be unlocked by

a)Try this command at ur sql plus query level

Go to cmd prompt.

Sqlplus /nolog

conn /as sysdba

this will take you to the sqlprompt.

Just execute the earlier commands there.

sqlplus>UPDATE SAP<schema>.usr02 set uflag=0 where mandt=<CLNT NO> and uflag=64; this statement actually unlocks the users of that particular client. So, try for every client in that sap system.

b) You can delete sap* user

Go to cmd prompt.

Sqlplus /nolog

conn /as sysdba

sqlplus>DELETE SAP<SID>.usr02 where mandt='CLIENT.NO' and bname=SAP*;

Note:-

After doing this restart the system. So, that a new user with the name "sap" gets generated with password "pass". Provided the parameter is set login/no_automatic_user_sapstar= 0 (Automatic user SAP is permitted).

regards,

kanthi

Re: Forgot password

Former Member — Sun, 22 Jul 2007 22:47:29 GMT

HI everyone,

Manoj here.

I am having problem with SAP* users password.

i am dng client referesh activity for client 950,then after client deletion for i am tring to login through SAP* user in client 950.

but it showing user lcoked.

then i tried to reset password from command prompt ,but it is giving error USR02 table does not exit

how can i reset the password for SAP* user in client 950(data is deleted from client.)

Re: Forgot password

Former Member — Wed, 29 Aug 2007 11:51:37 GMT

Perhaps you should first create the client once again, and the default system users are created along with the client.