Setup a HANA user account

From the SAP HANA Cockpit and connected with the HANA System Account, click on Manage Roles and Users. This will open the SAP HANA Web-based Development Workbench.

In order to allow the SYSTEM user to run any SQL statement, you will need to grant him the Developer role.

Under Security, expand Users, then double click on SYSTEM.

Select the Granted Roles tab, then click on the icon, then add the following role:

• sap.hana.ide.roles::Developer

Click on the button in the top menu bar

Using the menu bar icon, select Catalog.

The following screen should appear:

Click on the button in the top menu bar, and paste the following SQL code:

DROP USER PSTRIAL CASCADE;
CREATE USER PSTRIAL PASSWORD Welcome18Welcome18 NO FORCE_FIRST_PASSWORD_CHANGE;
ALTER USER  PSTRIAL DISABLE PASSWORD LIFETIME;

call _SYS_REPO.GRANT_ACTIVATED_ROLE ('sap.hana.ide.roles::Developer','PSTRIAL');
call _SYS_REPO.GRANT_ACTIVATED_ROLE ('sap.pa.apl.base.roles::APL_EXECUTE','PSTRIAL');

GRANT AFL__SYS_AFL_APL_AREA_EXECUTE TO PSTRIAL;
GRANT AFLPM_CREATOR_ERASER_EXECUTE TO PSTRIAL;

GRANT "CREATE SCHEMA" TO PSTRIAL;

GRANT REPO.READ on "public" TO PSTRIAL;
GRANT REPO.MAINTAIN_IMPORTED_PACKAGES on "public" TO PSTRIAL;
GRANT REPO.MAINTAIN_NATIVE_PACKAGES   on "public" TO PSTRIAL;

GRANT REPO.EDIT_NATIVE_OBJECTS   on "public" TO PSTRIAL;
GRANT REPO.EDIT_IMPORTED_OBJECTS on "public" TO PSTRIAL;

GRANT REPO.ACTIVATE_NATIVE_OBJECTS   on "public" TO PSTRIAL;
GRANT REPO.ACTIVATE_IMPORTED_OBJECTS on "public" TO PSTRIAL;

This script will delete any existing PSTRIAL user including its related object and tables.

Click on the Run button or press F8.

Click on the Logout icon located in the top right corner of the screen.

Now, you need to connect with your PSTRIAL HANA User Account.

Enter PSTRIAL as Username user name and Welcome18Welcome18 as Password, click on Logon.

If you can login, then your HANA User Account is properly configured.