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.

Note that actual parameter of password policy section is maintained by indexserver.ini system file. 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.

The last folder in SAP HANA Studio system navigation is Security and it has 3 subfolders inside it that define the system security policy and user management activities −SecurityUserRolesSecurity tab is used to manage Password Policy in HANA system −

To execute the table creation, click on the green arrow mark on the top right corner. You will get a confirmation as below that a column table has been created in Schema AA_HANA11 with name DEMO_TABLE −Statement 'create column table "AA_HANA11"."DEMO_TABLE"( "CUST ID" INTEGER null, "CUST NAME" VARCHAR (10) null)' successfully executed Affected Rows:0 in 5 ms 884 µs.

Following table type available in SAP HANA Studio −RowColumnTable Type − this can be changed later as per requirement