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.

SAP ABAP Expert

Updated on: 21-Feb-2020

2K+ Views

Kickstart Your Career

Get certified by completing the course

Get Started