Unlock User SAP*

[Former Member]

Dear all,

I lost SAP* and DDIC Password in client 000.

I deleted user SAP* from client 000 to reset it to pass.

but when i try to login it says

user locked too many failed attempts

Please help to resolve this Issue.

Best of Regards,

Gaurav Sood

[Henk · Accepted solution]

Hi Gaurav,

You need to delete the user from the database, not only as an SAP user. There are numerous posts about this topic, so you'll be able to find the right procedure for your database brand, I'm sure.

Regards,

Henk.

[Former Member · Accepted solution]

Dear Henk,

I tried to find it on SDN but couldn't find a relevent one.

can you help me with a suitable link or required search term.

Also someone said i should restart the system it will reset the password to pass,

Will this solution work ??

Thanks,

Gaurav Sood

[Former Member · Accepted solution]

Hello Gaurav,

The message you received seemed to indicate that SAP* is still in the user master record. How did you delete the SAP* account?

If you are running Oracle, you can run the following SQL directly at the DB level:

SQL> DELETE FROM <SCHEMA>.USR02 WHERE BNAME = 'SAP*' and MANDT='000';

SQL> COMMIT;

You also need to set profile parameter login/no_automatic_user_sapstar = 0 to allow you to log in to client 000 without the record in USR02.

In some case you may also need to restart the instance or sync the table buffers.

Hope above helps.

Regards, Chris.

[Former Member · Accepted solution]

Hi Cris,

I have done the same as you have described,

profile parameter login/no_automatic_user_sapstar = 0

SQL> DELETE FROM <SCHEMA>.USR02 WHERE BNAME = 'SAP*' and MANDT='000';

SQL> COMMIT;

SO i need to restart the system then it will take the password as pass

Thanks for the help,

Regards,

Gaurav Sood