Check Users Locked or deactivated in Hana or Hana Studio

Check Users;

select * from users where user_deactivated= ‘TRUE’;

Deactive hana user

We can use the following SQL query to DEACTIVATE HANA DB user ;

ALTER USER DEACTIVATE USER NOW;

Example ;

alter user HanaUser deactivate user now;

To activate the user again we can use the below SQL query ;

ALTER USER ACTIVATE USER NOW;

Example ;

alter user Hanauser activate user now;