Skip to Content

SAP HCP predictive services, Setup a HANA user account for the HCP predictive services

Previous

SAP HCP predictive services, Setup a HANA user account for the HCP predictive services

By Abdel Dadouche

Configure a user account with the relevant roles and privileges to use the SAP HCP predictive services

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

Details

Why create new user account?

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.


  1. 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.

    SAP HANA Cockpit
  2. Under Security, expand Users, then double click on SYSTEM.

    SAP HANA Web-based Development Workbench
  3. In order to allow the SYSTEM user to run any SQL statement, you will need to grant him the following role:

    • sap.hana.ide.roles::Developer

    Select the Granted Roles tab, then click on the plus icon, then add the roles listed above.

    Click on the save button in the top menu bar

    SAP HANA Web-based Development Workbench
  4. Using the navigation menu bar icon, select Catalog.

    The following screen should appear:

    SAP HANA Web-based Development Workbench
  5. Click on the SQL Console 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 Logout Run button or press F8.

    SAP HANA Web-based Development Workbench Login
  6. Click on the Logout Logout icon located in the top right corner of the screen.

    SAP HANA Web-based Development Workbench Login
  7. Now, you need to connect with your HCPPSTRIAL HANA User Account.

    Enter HCPPSTRIAL as Username user name and Welcome16 as Password, click on Logon.

  8. Your HANA User Account is now configured.

    SAP HANA Web-based Development Workbench

Next Steps

Updated 11/02/2016

Time to Complete

5 minutes

Beginner

Tags

Prerequisites

Next
Back to top