The goal of this lesson is to get to know the different ways to start and stop SAP HANA. As the administrator of SAP HANA database, you need to stop the system for maintenance purposes. SAP HANA Database could be …
The goal of this lesson is show some of the most important commands of HDBSQL. SAP HANA HDBSQL is a command line tool for entering and executing SQL statements, executing database procedures, and querying information about HANA database. You can …
This lesson describes how you can expand your HANA system. After completing this lesson you will be able to understand the basics of scale out and configuration of a distributed system. You can find detailed information in scale out at: …
After completing this exercise, you will be able to Create roles Assign privileges to role Create user Assign roles to user Create analytic privilege Task 1: Create a role and assign below privileges to it: add the role SELECT_SYS_BI to …
SAP HANA database facilitates the integration of different authentication methods. To integrate the SAP HANA database in your environment you need an overview of the supported authentication methods. There are following options available: Direct logon to database with user and …
After completing this lesson, you will be able to: explain the purpose of pre delivered roles explain what is template role explain the use of support role Business Example Standard roles are delivered for special tasks. You should know when …
After completing this lesson, you will be able to: explain the purpose of pre delivered roles explain what is template role explain the use of support role Business Example Standard roles are delivered for special tasks. You should know when …
There are different types of privileges in authorization concept. You should have good understanding of each type of privilege to grant users the right privilege. System Privileges These are used for administrative tasks, they are assigned to users and roles. …
In this lesson, we will learn: User and role concept, creation and management Grant/Revoke/Assign privilege to users The users of SAP HANA database require their own credentials to log on. The administrator has to set up user id and roles …
After completing this lesson, you will be able to:• Configure SAP Data Services for Metadata Import You are using SAP Data Services to load data into HANA. You have to perform basic configuration as an administrator. Below are the steps: …