manager locked in one company in SAP Business One HANA

[former_member594505]

Hello:

In SAP Business One for HANA, the manager user is locked in only one company database. He can log in to other companies. And, his User Setup window does not show the "Locked" box as checked.

What script can I run in HANA to unlock the user? Unless there is a safe way to do so in the B1 app, I'm going to have to go the HANA route.

I'm a HANA newbie who comes from a SQL background. So, please help me out.

Thanks!

John

[former_member588507]

this for when you forgot password but when id locked you have just change the status of locked field in ousr table for manager id don't try above solution.

[former_member594505]

Hello:

Where can I find the OUSR table in HANA? In which database?

John

[kothandaraman_nagarajan]

Hi,

If its production company, please raise ticket to SAP to unlock.

Do you have any other super user other than manger in that company? If yes, then other super user can unlock manager ID.

Regards,

Nagarajan

[former_member588507]

Hi John,

First Take full backup of database and restore it as test db then try this -when id locked you have just change the status of locked field in ousr table for manager id by edit top 200 rows.

Note- Use this method as a last option if you have any other solution then go for that.

Regards,

Satish Gupta

[jitin_chawla]

Hi,

If your Manager ID was Superuser and no other Superuser in the system, then you would not be able to reset the password and unlock the Manager ID.

In such a case, check SAP Note 978292 regarding the issue.

Regards,

Jitin

[siwantham]

Please try this script in HANA Studio.

UPDATE OUSR
SET "Locked" = 'N'
WHERE "USER_CODE" = 'manager';