How to Lock/Unlock User in SAP HANA DB using SQL query?

[former_member1244203]

Hi,

How to Lock/Unlock User in SAP HANA Database using SQL query?

Regards,

Ram

[VivekSahu]

You asked a question. Don't forget to mark the answer that helped you most as correct. Thanks!

For the readers, before you leave, don't forget to up/down vote the answers. You can vote on the question too.
Thanks!

[VivekSahu · Accepted solution]

Hello Ram,

-- Deactivating user
ALTER USER <user_name> DEACTIVATE USER NOW;
-- Activating user
ALTER USER <user_name> ACTIVATE USER NOW;

USER ADMIN privilege is needed to execute the above commands.

Best Regards,
Vivek Sahu

[former_member1244203 · Accepted solution]

Thanks Vivek. It worked. I am new to HANA DB and integrating this in my Java application.