How to lock unlock user in SAP HANA DB

 You just need to login to a hdbsql with a user which has USER_ADMIN privilege's  and use the following :-

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

Comments