How to deactivate user in SAP HANA using sql


The administrator can deactivate a user account with the following SQL command:

ALTER USER <user_name> DEACTIVATE USER NOW

After the user account is deactivated, the user cannot log on to the SAP HANA database until
the administrator resets the user‟s password.




Tags: SAP HANA deactivation of users , sql query to deactiactivate user in HANA db, hana security,
Share this article :

Post a Comment

 
Copyright © 2011. SAP HANA TUTORIALS FREE - S/4 HANA - All Rights Reserved