how to unlock Account

[Former Member]

in our QAS 000 client we forgot the password for SAP* , DDIC and one jeneric id.

now the account was locked. please help how to reset SAP * this account.

thanks in advance.

Regards

deepak

[Former Member]

Hi,

May I know which OS and DB are using for your system?

If Oracle DB using then:

For example-

SQL> select mandt,bname,uflag from sap<sid>.usr02 where bname like 'DDIC';

Update uflag value to '0' for unlock by this command:

SQL>update sap<sid>.usr02 set uflag=0 where mandt='000' and bname like 'DDIC';

Here sap<sid> refer to 'dbs_ora_schema' value.

usr02 is table name where all the details of users stored.

Note: sometimes we may need to restart the system for updating the buffer use TC /$SYNC

Regards,

Raghu

[ImtiazKaredia]

Hi,

In Profile file, make parameter login/no_automatic usersapstar to 1 and restart SAP for it to take effect.

Then at SQL prompt, delete user SAP* from table USR02.

Now login to SAP with user as SAP* and pasword as PASS

Thanks

Imtiaz

[ImtiazKaredia]

Hi,

Typing mistake please set login/no_automatic_user_sapstar to 0.

Thanks

[Former Member]

dear Imtiaz

i dont want to delete SAP * from 000 client.is there any other way to reset the password.

regards

deepak

[ImtiazKaredia]

Hi

I don't think there is any other way to reset password.

Thanks

Imtiaz

[Former Member]

" I dont want to delete SAP * from 000 client" --> YOU cannot delete him , after you delete him in from table USR02 , the SAP * are recreate again with standart password PASS. It's only 1 way.

Also the sap<sid> not always SAP scheme --> in old releases the shema is SAPR3 the new (NW 7) is SAPSR3.

Regards.

[Former Member]

Hi Sergo,

This part: "after you delete him in from table USR02 , the SAP * are recreate again with standart password PASS" has always confused me.

I am not sure but I think SAP* is kind of hard coded and in the first time login it doesnot exist in USR02. At the time of login SAP perhaps checks if SAP* exists in USR02. If it does then it asks for correct password otherwise it would accept pass.

What is your take on this?

Regards.

Ruchit.

[Former Member]

Hi MR. Ruchit Khushu. Yes you are right on how many I understand. It is the most probable "is kind of hard coded", but that the person would not be afraid, it is possible to notice that it to be recreated Regards.

[Former Member]

Hi Sergo,

I am just Ruchit. Mr. Ruchit Khushu makes me look a old guy )

Regards.

Ruchit.

[Former Member]

dear raghu,

we are using one jeneric id that is Solution. dis was also locked . is there any way to unlock the solution id.

regarads

deepak

[Former Member]

Deepak,

Try this:

You can replace the DDIC user with solution user and try to change uflag value to 0 at sql prompt. It will unlock the solution user also.

At sql propmt:

select * from sapsr3.usr02 where bname='sap*' and mandt='000';

If you got as "0 records selected'.

means sap* user does not exists in client 000.

if you are able to login into sap client ( other then 000)

run RZ10 and edit instance profile and make following entry.

login/no_automatic_user_sapstar -> 0

save and activate instance profile. restart sap server.

Login to client 000 with sap* and password 'pass' and unlock solution user.

Regards,

Raghu

Edited by: Raghavendra Ambati on Apr 1, 2008 1:09 PM