cancel
Showing results for 
Search instead for 
Did you mean: 

manager locked in one company in SAP Business One HANA

former_member594505
Active Participant
0 Kudos

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
Participant
0 Kudos

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.

Accepted Solutions (0)

Answers (5)

Answers (5)

former_member594505
Active Participant
0 Kudos

Hello:

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

John

kothandaraman_nagarajan
Active Contributor
0 Kudos

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
Participant
0 Kudos

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
Advisor
Advisor
0 Kudos

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
Newcomer
0 Kudos

Please try this script in HANA Studio.

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