You will learn
- How to create a new user account on your HANA MDC instance using the SAP HANA Cockpit
- What are the roles and privileges required to use the SAP HCP predictive services
Configure a user account with the relevant roles and privileges to use the SAP HCP predictive services
Each Trial HANA MDC instance comes with a HANA System Account. This user account shall be used only to execute “System” related activities.
In the “real world”, it is uncommon to use this user account to develop an “end-user” application.
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.
Under Security, expand Users, then double click on SYSTEM.
In order to allow the SYSTEM user to run any SQL statement, you will need to grant him the following role:
Select the Granted Roles tab, then click on the icon, then add the roles listed above.
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 HCPPSTRIAL CASCADE; CREATE USER HCPPSTRIAL PASSWORD Welcome16 NO FORCE_FIRST_PASSWORD_CHANGE; ALTER USER HCPPSTRIAL DISABLE PASSWORD LIFETIME; call _SYS_REPO.GRANT_ACTIVATED_ROLE ('sap.hana.ide.roles::Developer','HCPPSTRIAL'); call _SYS_REPO.GRANT_ACTIVATED_ROLE ('sap.pa.apl.base.roles::APL_EXECUTE','HCPPSTRIAL'); GRANT "CREATE SCHEMA" TO HCPPSTRIAL; GRANT REPO.READ on "public" TO HCPPSTRIAL; GRANT REPO.MAINTAIN_IMPORTED_PACKAGES on "public" TO HCPPSTRIAL; GRANT REPO.MAINTAIN_NATIVE_PACKAGES on "public" TO HCPPSTRIAL; GRANT REPO.EDIT_NATIVE_OBJECTS on "public" TO HCPPSTRIAL; GRANT REPO.EDIT_IMPORTED_OBJECTS on "public" TO HCPPSTRIAL; GRANT REPO.ACTIVATE_NATIVE_OBJECTS on "public" TO HCPPSTRIAL; GRANT REPO.ACTIVATE_IMPORTED_OBJECTS on "public" TO HCPPSTRIAL;
This script will delete any existing
HCPPSTRIAL 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
HCPPSTRIAL HANA User Account.
HCPPSTRIAL as Username user name and
Welcome16 as Password, click on Logon.
Your HANA User Account is now configured.