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.

This can be defined under Password policy → Miscellaneous

Yes, new for SPS7 is the Lock indefinitely radio button −

This can be found using following SQL command −SELECT * from USERS;

The system view M_PASSWORD_POLICY contains the parameters and their current values.

In SAP HANA, password policy parameters for the system database of a multiple-container system are maintained in the namesever.ini file and not the indexserver.ini file.

To enable Audit policy, navigate to Security tab → AuditingUnder Auditing, you need to enable Auditing policy as shown below −

This can be done under a Blocked password option under the password management policy. Below shows SAP HANA cockpit snapshot −

Following privileges are required −You need to have the system privilege INIFILE ADMIN.You need to have the object privileges SELECT, INSERT, and DELETE for the _SYS_PASSWORD_BLACKLIST table (_SYS_SECURITY).

It is recommended that password policy should be configured using Security editor of SAP HANA Studio however this can also be done by editing indexserver.ini file.Note that direct changes to the indexserver.ini file cannot be audited.