Create User SQL in SAP HANA database

You can achieve this by running the below SQL query −

>CREATE USER TEST password “Welcome1$$”  VALID FROM ‘2017-12-05 11:00:00’
UNTIL ‘2018-12-08 12:00:00’;

CREATE USER DUMMY password “Welcome1$$”  VALID FROM NOW UNTIL FOREVER;

Note that password passed in this SQL should meet password policy of SAP HANA system otherwise user creation will be failed.