Learn SAP BTP HANA Cloud with User and Role Management

Name: Learn SAP BTP HANA Cloud with User and Role Management
Rating: 4.6 (60 reviews)

Start SAP BTP HANA Cloud Journey with Administration and Security using HANA Cockpit, SAP BTP, CAP and HANA DB Explorer

Created bySAP CloudMax, SAP TutorPro

Last updated 7/2025

English

English [Auto],

What you'll learn

Learn in detail about - SAP HANA Cloud, HANA Cloud Central, HANA Cockpit, Database Explorer, BTP & BAS.
Step by step detailed guide on SAP HANA Cloud Security - User Management & Role Management
Introduction to SAP HANA Cloud. Architecture of HANA Cloud, SAP HANA (on-premise) Vs SAP HANA Cloud
Understand about - SAP BTP Key Terms, Place of HANA Cloud in SAP BTP Account Model
Create Multi-Environment edition of HANA Cloud, Assign Role Collections to access HANA Cloud
Create HANA Cloud Database Instances - Database Instance & Datalake Instance
Explore HANA Cloud Database Instance - Technical details, Monitoring Tiles, Configurations & System Services
Create standalone HANA Cloud, Data Lake Instance & Create DB Instances at Space Level
Learn to Create & Configure the CAP project and Prepare CAP project for Development.
Create design-time database(DB) objects in CAP Project, Create HDI Container service instance & Bind it to CAP project
Locally deploy design-time DB Objects to HANA Cloud & Check generated runtime objects in HANA Database Explorer
Build & Deploy CAP Project to deploy Design Time DB Objects to SAP HANA Cloud
Learn about SAP HANA Database(DB) Explorer - Explore Properties of DB Instance & DB artifacts from Catalog
Add HANA Cloud DB Instances at SAP HANA DB Explorer - Add Cockpit DB, HANA DB, Data Lake & HDI Container Instance
Explore technical details of Tables from HANA DB Explorer & Import data into DB Tables.
Create new DB Table using csv file at Catalog level & Explore table operations at HANA DB Explorer
Query with SQL Console in HANA DB Explorer - Execute different SQL queries & check output windows like Results, History
Query SQL Console in HANA Cloud Central - Connect / Disconnect to DB Instance
Run SQL Query as background activity & Run on multiple Databases. Connect SQL Console to different Databases
Learn about HANA Cloud Users - SAP Owned Users, Standard Users Vs Restricted Users
Learn about DBADMIN User - Conventions to use, Explore detail view, Check Object & System Privileges of DBADMIN
Explore SAP HANA Cockpit. Check 'Security & User Management' view
Create HANA Cloud Users using SQL Console & using HANA Cockpit. Set Authentication Properties.
Manage HANA Cloud Users - Edit, Activate / Deactivate, Delete
Learn about HANA Cloud User Groups - Need, Properties, Tasks & ways to create User Group. Explore 'User Group Management'
Create HANA Cloud User Group using HANA Cockpit - Assign Users & Create a new users in User Group. Set Password Policy & Explore 'User Group Management'.
Explore System Views for User (SYS_USER) & User Group (SYS_USERGROUP) in Database Explorer
Understand Authentication in HANA Cloud - Explore Authentication Methods as User Name & Password, SAML etc...
Understand Privileges in HANA Cloud - Use & Properties, Privileges Vs Roles, Explore System & Object Privileges and its use-cases
Understand relation between Users, User Groups & Privileges - Assign Privileges using DBADMIN & using Standard User
Create User Group & Assign Privileges using SQL Console - Need, Create User & Group with Standard User as Admin
Explore Roles in Role Management, Edit Role & Edit Privileges assigned to the Role. Check Role Groups
Create Catalog Roles using HANA Cockpit & Check relation between Users, Roles & Privileges.
Create HDI Roles using BAS. Generate design-time object for HDI Role & deploy it to HANA Cockpit to create HDI Role.
Apply & Test Catalog Role and HDI Role on Database Table.

Course content

7 sections • 53 lectures • 7h 7m total length

Introduction10:21
Explore SAP Hana Cloud with user and role management through hands-on course that guides you to create database instances, design-time objects with CAP project, and manage users, groups, and roles.

Introduction to SAP HANA Cloud - Part 14:40
What is Cloud Technology?
Need of Cloud Solutions & Rise of SAP BTP
SAP BTP Database Management & SAP HANA Cloud
Introduction to SAP HANA Cloud - Part 25:12
What is SAP HANA Cloud?
Features of HANA Cloud
Use-cases of HANA Cloud
Tool-box for HANA Cloud
Architecture of SAP HANA Cloud4:07
SAP HANA (on-premise) Vs SAP HANA Cloud
Architecture of SAP HANA Cloud
Ways to start with SAP HANA Cloud7:18
using SAP BTP Trial Account
using SAP HANA Cloud Trial Account
ways to start with SAP BTP Trial Account
Create SAP BTP Trial Account8:30
Register/Log into SAP website
Activate the SAP Account
Log on to SAP BTP Trial Account
Verify the SAP BTP Trial Account
Understanding SAP BTP Key Terms11:43
Global Account & Directory
Subaccount & Environment
Space & Organization
Services & Service Plans
Entitlements & Quotas
Place of HANA Cloud in SAP BTP Account Model2:10
Place of S H Cloud at Subaccount Level
Place of S H Cloud at Space Level

Getting Started to Create SAP HANA Cloud DB Instances15:09
Ways to create HANA Cloud - a) Subaccount, b) Space Level
Create Multi-Environment edition of HANA Cloud
Assign Role Collections to access HANA Cloud
Understanding SAP HANA Cloud Central2:12
What is HANA Cloud Central
Use-cases of HANA Cloud Central
Create SAP HANA Cloud DB Instances13:14
Create HANA Cloud Instance at Subaccount Level
Create SAP HANA Cloud, SAP HANA Database Instance
Create SAP HANA Cloud, Datalake Instance
Explore HANA Cloud DB Instance Details13:10
Explore technical details of HANA Cloud DB Instance
Overview of Monitoring Tiles of HANA Cloud DB Instance
Explore System Services, Connections & Configuration
Explore technical details of HANA Cloud Datalake Instance
Manage HANA Cloud DB Instances5:50
Explore 'Actions' of HANA Cloud DB Instances
Start & Stop the DB instances
Delete the DB Instances
HANA Cloud Instance Mapping in Manage Configuration7:31
Importance of HANA Cloud Instance Mapping
Understanding Instance mapping to CF & Kyma Environments
Understanding Instance Mapping with & without Space ID
Create HANA Cloud DB Instances at Space Level7:22
Create SAP HANA Cloud, SAP HANA Database Instance (CF Edition)
Explore created HANA Cloud DB Instance at service section
Create HANA Cloud Data Lake Standalone Instance5:16
Need of standalone Datalake Instance
Create SAP HANA Cloud, Datalake Instance (Multi-Env. Edition)

Start design-time Object Creation Process & Navigate to BAS7:38
Design-time objects & BAS
Create Dev Space & Add SAP Extensions
Need to Start HANA Cloud Instances in Trial Account
Prepare CAP Project for Development6:01
Modifications in mta.ymal file
Modifications in package.json file
Install dependencies
Generate additional files in db folder
Create design-time Objects in CAP Project5:05
Create Database Entities in db folder
Create Service Interfaces in srv folder
Generate design-time Objects
Deploy design-time DB objects to HANA Cloud (Local Deploy)10:32
Ways to convert design-time objects to runtime objects
Create HDI Container service instance & Bind it to CAP project
Check Service Key of Service Instance
Deploy design-time objects to HANA Cloud
Check generated runtime objects in HANA DB Explorer
Deploy design-time DB objects to HANA Cloud (Build + Deploy) - Part 18:29
Delete HDI Container service instance
Build the CAP Project to generate .mtar file
Deploy the CAP Project
Deploy design-time DB objects to HANA Cloud (Build + Deploy) - Part 210:27
Resolution of common deployment error
Re-deploy the CAP Project
Explore generated HDI Container Service Instance
ways to navigate to SAP HANA Database Explorer

Walkthrough of SAP HANA Database Explorer8:29
Explore Properties of DB Instance
Explore DB artifacts from Catalog
Add & Remove Database Instances
Add HANA Cloud DB Instances at DB Explorer12:00
Add Cockpit Database Instance. Check Host/Instance ID.
Add SAP HANA Cloud, SAP HANA DB Instance
Add SAP HANA Cloud, SAP HANA Datalake Relational Engine
Add HDI Container Instance
Import Data into Database Tables - Part 110:58
Explore technical details of Tables from DB Explorer
Explore - Open Data, Dependency, Create Shortcut
Load Data into Database Tables
Import Data into Database Tables - Part 214:50
Table Operations - Change, Insert, Delete, Sort, Filter
Table Operations - Download, Export Data & Catalog Objects
Create table using csv file at Catalog level
Query with SQL Console in Database Explorer - Part 112:33
Types of Querying with SQL Console
SELECT, INSERT, DELETE, UPDATE, JOIN Queries
Check output windows like Results, Messages, History
Query with SQL Console in Database Explorer - Part 27:36
Run as background activity, Run on Multiple Databases
Download/Upload SQL Queries
Connect SQL Console to different Databases
Query with SQL Console in SAP HANA Cloud Central5:15
Ways to navigate to SQL Console from HANA Cloud Central
Connect / Disconnect to DB Instance
SQL queries & output windows

SAP HANA Cloud Users : Key Concepts9:00
Understanding SAP owned Users
Understanding Customer owned DB Users & Technical DB Users
Understanding Standard Users & Restricted Users
SAP HANA Cloud Users : DBADMIN, Predefined Users4:27
Understanding DBADMIN User
Conventions on use of DBADMIN
Walkthrough of Predefined users
Walkthrough of HANA Cockpit & User Management view6:36
Navigate to SAP HANA Cockpit
Navigate to the view 'Security & User Management'
Explore User Management & Check detail view of Standard Users
Explore DBADMIN in User Management4:09
Check detail view of DBADMIN
Explore Object & System Privileges of DBADMIN user
Create HANA Cloud Users using SQL Console8:34
Create Standard User with CREATE statement
Set Authentication properties using SQL Console
Create Restricted User & Set Authentication properties
Create HANA Cloud Users using SAP HANA Cockpit7:41
Create Standard User & set Authentication properties
Create Restricted User & set Authentication properties
Manage HANA Cloud Users (Edit, Deactivate, Delete)8:15
Edit HANA Cloud User
Activate / Deactivate HANA Cloud User
Delete HANA Cloud User
Understanding HANA Cloud User Groups2:17
What is SAP HANA Cloud User Groups?
Properties & Tasks of User Groups
Ways to create User Group
Getting started to create HANA Cloud User Group3:56
Need to create separate User Groups
Explore 'User Group Management' in SAP HANA Cockpit
Explore User Group detail page
Create HANA Cloud User Group using SAP HANA Cockpit8:18
Create a new HANA Cloud User Group
Assign Users in User Group & Create a new user in User Group
Set Password Policy for User Group
Explore System Views for User & User Group8:13
Explore System View for User in DB Explorer
Explore System View for User Group in DB Explorer

Relation between Users, User Groups & Privileges - Part 16:55
Check default privileges on creation of any new User
Login with different User on SAP HANA Cockpit
Need of Object & System Privileges to Cloud Users
Relation between Users, User Groups & Privileges - Part 215:16
Assign Object Privileges to standard users using DBADMIN
Assign System Privileges to standard users using DBADMIN
Create new User Group & Users using Standard User
Create User Group & Assign Privileges using SQL Console - Part 19:46
Create User Group & using DBADMIN & in SQL Console
Need of User Group assignment during new User creation using SQL Console
Assign Object & System Privilege using SQL Console
Create User Group & Assign Privileges using SQL Console - Part 26:23
Login to SQL Console with Standard User as Admin
Create User Group & User with Standard User as Admin & in SQL Console
Understanding Authentication in SAP HANA Cloud5:43
What is Authentication in SAP HANA Cloud?
Explore Authentication Methods - a) User Name & Password, b) SAML
Explore Authentication Methods - c) JWT, d) X.509 Client Cert. e) LDAP Server
Understanding Privileges in SAP HANA Cloud10:07
What is Authorization? Difference between Roles & Privileges
What is Privileges? Use & Properties of Privileges
System Privileges - Use-cases & Explore it in Privilege Assignment
Object Privileges - Use-cases & Explore it in Privilege Assignment
Understanding DB Roles in SAP HANA Cloud6:35
What is DB Roles in HANA Cloud? Use-case of Roles
Types of Roles. Difference between Catalog Roles & HDI Roles
Explore Roles in Role Management6:16
Navigate to Role Management view
Explore detail page of Role
Edit Role. Edit Privileges assigned to the Role. Explore Role Groups
Create Catalog Roles in Role Management6:53
Create catalog roles in role management by aggregating existing roles, adding system and object privileges, and assigning users via the Cloud Max super admin in SAP HANA Cloud.
Relation between Users, Roles & Privileges11:45
Create module specific Admin Role & add Privileges to it
Create Admin Role & assign Admin Role to it
Importance of Privilege assignment via Role
Apply & Test Catalog Role on Database Table9:16
Restrict End Users from Editing / Deleting Table Data
Assign Role with SELECT privilege on a DB table to the End User
Test to check if end user can edit / delete table data
Create HDI Roles in Role Management10:37
Create hdbrole file & write code for HDI Role in BAS
Generate design time object for HDI Role & deploy it to HANA Cockpit
Explore newly created HDI Role in Role Management
Apply & Test HDI Role on Database Table6:41
Assign HDI Role to end User with Grantor as Current User
Test to check if end user can edit / delete table data

Requirements

Basic Understanding of SAP

Description

This course will definitely help you to start your SAP BTP HANA Cloud journey starting from the HANA Cloud concepts to the Creation of DB Instances, User & Role Management with HANA Cockpit & DB Explorer

The course is carefully designed and topics have been explained in detail, step-by-step and simple manner.

Course Goals -

Learn about SAP HANA Cloud, HANA Cloud Central & HANA Cockpit
Create HANA Cloud DB Instances, Manage it, Explore details of it, Do Instance mapping in Manage Configuration
Create design-time DB Objects using CAP Project and Deploy it to HANA Cloud
Explore generated Runtime objects in HANA DB Explorer
Explore SAP HANA DB Explorer, Add HANA Cloud DB Instances & query with SQL Console in Cloud Central & in DB Explorer
Learn HANA Cloud User Management - Explore HANA Cockpit User Management. Create & Manage Users, User Groups using HANA Cockpit & SQL Console
Learn HANA Cloud Role Management - Create Privileges, Authentication, Catalog & HDI Roles. Learn & Test relation between Users, Roles & Privileges

Concepts you will learn -

About SAP HANA Cloud - It's Need, Architecture, Features, Use-cases & Place of HANA Cloud in SAP BTP Account Model
About SAP BTP Key Terms. What is HANA Cloud Central? What is HANA Cockpit? What is HANA DB Explorer?
How to create different types of Cloud DB Instances? How to manage DB Instances? Need of Instance Mapping.
Design-Time Vs Runtime DB Objects. Need to configure CAP Project to create design-time objects.
How to add different types of Cloud DB Instances in DB Explorer? Explore technical details of DB artifacts & Import Data. Query with SQL Console.
Conventions for DBADMIN, Standard Vs Restricted Users. How to Create Cloud Users & Groups using SQL Console & HANA Cockpit.
About Privileges, Authentication, DB Roles, Catalog Vs HDI Roles. How to apply Roles on DB objects?
Relation between Users, User Groups & Privileges. Relation between Users, Roles & Privileges.

You will learn step-by-step -

Step by step detailed guide for beginners to Create HANA Cloud DB Instances using SAP BTP & Cloud Central
1. Create Multi-Env edition of HANA Cloud, Assign Role Collections to access HANA Cloud
2. Create HANA Cloud Database Instances - Database Instance & Datalake Instance
3. Check HANA Cloud Database Instance - Technical details, Monitoring Tiles, Configurations & System Services
4. Manage HANA Cloud DB Instances & Do Instance mapping in Manage Configuration
5. Create standalone HANA Cloud, Data Lake Instance & Create DB Instances at Space Level

Step by step guide to create Design Time Database Objects
1. Create & Configure the CAP project and Prepare CAP project for Development
2. Create Design Time DB Objects in CAP Project, Create HDI Container service instance & Bind it to CAP project
3. Locally Deploy Design Time DB Objects to HANA Cloud & Check generated runtime objects in HANA DB Explorer
4. Build & Deploy CAP Project to deploy Design Time DB Objects to SAP HANA Cloud
Step by step guide about SAP HANA DB Explorer, to add HANA Cloud DB Instances & Query with SQL Console
1. Add HANA Cloud DB Instances at SAP HANA DB Explorer - Add Cockpit DB, HANA DB, Data Lake & HDI Container Instance
2. Explore SAP HANA Database(DB) Explorer to check Properties of DB Instance & DB artifacts from Catalog
3. Check technical details of Tables from HANA DB Explorer & Import data into DB Tables
4. Create new DB Table using csv file at catalog level & Perform table operations at HANA DB Explorer
5. Query with SQL Console in HANA DB Explorer & in HANA Cloud Central
Step by step about User Management & Role Management in HANA Cockpit
1. Check 'Security & User Management' Tile from HANA Cockpit. Know about DBADMIN user, Standard Users Vs Restricted Users
2. Create HANA Cloud Users using SQL Console & using HANA Cockpit. Set Authentication & Manage Cloud Users
3. Create HANA Cloud User Group - Assign Users & Create a new users in it. Set Password Policy.
4. Check Authentication & Privileges in HANA Cloud, Privileges Vs Roles, Explore System & Object Privileges
5. Create Catalog Roles using HANA Cockpit & HDI Roles using BAS. Test Catalog & HDI Roles on Database Table
6. Know relation between Users, Groups, Role & Privileges - Assign Privileges using DBADMIN & using Standard User

Who this course is for:

Students or Employees who want to learn SAP BTP & SAP HANA Cloud
SAP Cloud Administrators & BASIS Consultants
SAP BTP Project Team members

Learn SAP BTP HANA Cloud with User and Role Management

What you'll learn

Explore related topics

Course content

Introduction1 lecture • 10min

Introduction to SAP HANA Cloud7 lectures • 44min

Getting Started with SAP HANA Cloud with Instance Creation & Configuration8 lectures • 1hr 10min

Create design-time Database Objects and deploy it to SAP HANA Cloud6 lectures • 48min

Explore SAP HANA DB Explorer, HANA Cloud DB Instances & SQL Console7 lectures • 1hr 12min

SAP HANA Cloud User Management11 lectures • 1hr 11min

SAP HANA Cloud Role Management13 lectures • 1hr 52min

Requirements

Description

Who this course is for: