Rating 4.61 out of 5 (9 ratings in Udemy)
What you'll learn
- In this course, students will learn HANA DB 2.0 security with the help of over 100+ short and to the point videos. Each topic has been split into multiple short videos to make it comfortable for the students to learn.
Description
In this course, students will learn HANA DB 2.0 security with the help of over 100+ short and to the point videos. Each topic has been split into multiple short videos to make it comfortable for the …
Rating 4.61 out of 5 (9 ratings in Udemy)
What you'll learn
- In this course, students will learn HANA DB 2.0 security with the help of over 100+ short and to the point videos. Each topic has been split into multiple short videos to make it comfortable for the students to learn.
Description
In this course, students will learn HANA DB 2.0 security with the help of over 100+ short and to the point videos. Each topic has been split into multiple short videos to make it comfortable for the students to follow and learn.
Topics covered in this course include:
INTRODUCTION TO SAP HANA STUDIO
INTRODUCTION TO HANA STUDIO - ADMINISTRATION CONSOLE
INTRODUCTION TO HANA STUDIO - PERSPECTIVES
INTRODUCTION TO PRIVILEGES
SYSTEM PRIVILEGES
OBJECTPRIVILEGES
ANALYTIC PRIVILEGES
PACKAGE PRIVILEGES
APPLICATION PRIVILEGES
CATALOG OBJECTS
OVERVIEW
SCHEMAS
TABLES
REPOSITORY OBJECTS
SCHEMAS
TABLES
USER ACCOUNT ADMINISTRATION
OVERVIEW
USING SQL STATEMENTS
USING SAP HANA STUDIO
USING SAP HANA WEB IDE
USER VIEWS
DELETING USERS
CONVERTING USER IDs in HANA DB
CONVERTING USER IDs in HANA DB - DEMO OF USING RESTRICTED USER ID
GRANTING AND REVOKING PRIVILEGES - SYSTEM PRIVILEGES - SQL STATEMENTS
GRANTING AND REVOKING PRIVILEGES - CATALOG SCHEMA - SQL STATEMENTS
GRANTING AND REVOKING PRIVILEGES - REPOSITORY SCHEMA - SQL STATEMENTS
GRANTING AND REVOKING PRIVILEGES - APPLICATION PRIVILEGES - SQL STATEMENTS
GRANTING AND REVOKING PRIVILEGES - REPOSITORY ANALYTIC PRIVILEGES - SQL STATEMENTS
GRANTING AND REVOKING PRIVILEGES - PACKAGE PRIVILEGES - SQL STATEMENTS
GRANTING AND REVOKING PRIVILEGES - HANA STUDIO
GRANTING AND REVOKING PRIVILEGES - WEB IDE
GRANTING AND REVOKING ROLES - CATALOG ROLES - SQL STATEMENT
GRANTING AND REVOKING ROLES - REPOSITORY ROLES - SQL STATEMENT
GRANTING AND REVOKING ROLES - REPOSITORY ROLES - SAP HANA STUDIO
GRANTING AND REVOKING ROLES - ROLES - SAP HANA WEB IDE
DATABASE ROLES
OVERVIEW
CREATING AND DELETING ROLES - SQL STATEMENTS
CREATING AND DELETING ROLES - SAP HANA STUDIO
CREATING AND DELETING ROLES - SAP HANA WEB IDE
GRANTING AND REVOKING PRIVILEGES - SYSTEM PRIVILEGES - USING SQL STATEMENTS
GRANTING AND REVOKING PRIVILEGES - CATALOG SCHEMAS - USING SQL STATEMENTS
GRANTING AND REVOKING PRIVILEGES - REPOSITORY SCHEMAS - USING SQL STATEMENTS
GRANTING AND REVOKING PRIVILEGES - CATALOG OBJECTS - USING SQL STATEMENTS
GRANTING AND REVOKING PRIVILEGES - REPOSITORY OBJECTS - USING SQL STATEMENTS
GRANTING AND REVOKING PRIVILEGES - REPOSITORY ANALYTIC PRIVILEGES - USING SQL STATEMENTS
GRANTING AND REVOKING PRIVILEGES - APPLICATION PRIVILEGES - USING SQL STATEMENTS
GRANTING AND REVOKING PRIVILEGES - PACKAGE PRIVILEGES - USING SQL STATEMENTS
GRANTING AND REVOKING PRIVILEGES - USING SAP HANA STUDIO
GRANTING AND REVOKING PRIVILEGES - USING SAP WEB IDE
NESTED ROLES
REPOSITORY ROLES
OVERVIEW
CREATING REPOSITORY ROLE - PART 01
CREATING REPOSITORY ROLE - PART 02
CREATING REPOSITORY ROLE - PART 03
CREATING REPOSITORY ROLE - PART 04
CREATING REPOSITORY ROLE - PART 05
CREATING REPOSITORY ROLE - PART 06
CREATING REPOSITORY ROLE - PART 07
CREATING REPOSITORY ROLE - PART 08
CREATING REPOSITORY ROLE - PART 09
CREATING REPOSITORY ROLE - USING SAP HANA WEB IDE
GRANTING REPOSITORY ROLES TO USERS - WITH STORED PROCEDURES
GRANTING REPOSITORY ROLES TO USERS - WITH SAP HANA STUDIO AND WEB IDE
REPOSITORY ROLES - SECURITY ADMINISTRATOR ROLE
REPOSITORY ROLES - BASIS ADMINISTRATOR ROLE
SYSTEM PRIVILEGES
RELATED TO DEVELOPMENT
RELATED TO SECURITY ADMINISTRATION
RELATED TO SYSTEM ADMINISTRATION
GRANTING TO USERS AND STANDARD ROLES
GRANTING TO REPOSITORY ROLES
OBJECT PRIVILEGES
OVERVIEW
GRANTING AND REVOKING PRIVILEGES USING SQL STATEMENTS
GRANTING AND REVOKING PRIVILEGES USING SAP HANA STUDIO AND WEB IDE
GRANTING AND REVOKING PRIVILEGES USING REPOSITORY ROLES
PACKAGE PRIVILEGES
OVERVIEW
GRANTING PACKAGE PRIVILEGES - USING SQL
GRANTING PACKAGE PRIVILEGES - WITH SAP HANA STUDIO AND SAP HANA WEB IDE
GRANTING PACKAGE PRIVILEGES - WITH REPOSITORY ROLES
ANALYTIC PRIVILEGES
INFORMATION VIEWS - OVERVIEW
CLASSICAL ANALYTIC PRIVILEGE - PART 1
CLASSICAL ANALYTIC PRIVILEGE - PART 2
CLASSICAL ANALYTIC PRIVILEGE - PART 3
SQL ANALYTIC PRIVILEGE - PART 1
SQL ANALYTIC PRIVILEGE - PART 2
SQL ANALYTIC PRIVILEGE - PART 3
DYNAMIC CLASSICAL ANALYTIC PRIVILEGE - PART 1
DYNAMIC CLASSICAL ANALYTIC PRIVILEGE - PART 2
DYNAMIC SQL ANALYTIC PRIVILEGE - PART 1
DYNAMIC SQL ANALYTIC PRIVILEGE - PART 2
GRANTING ANALYTIC PRIVILEGES
GRANTING ANALYTIC PRIVILEGES USING REPOSITORY ROLE
AUDITING
USING HANA STUDIO
USING SAP HANA WEB IDE
USING SQL STATEMENTS
QUERYING AUDIT DATA
TROUBLESHOOTING
TRACING USING SAP HANA STUDIO
TRACING USING SQL STATEMENTS
EFFECTIVE PRIVILEGES - GRANTED_PRIVILEGES
EFFECTIVE PRIVILEGES - GRANTED_ROLES
EFFECTIVE PRIVILEGES - ACCESSIBLE_VIEWS
EFFECTIVE PRIVILEGES - EFFECTIVE_PRIVILEGE_GRANTEES
EFFECTIVE PRIVILEGES - EFFECTIVE_STRUCTURED_PRIVILEGES
EFFECTIVE PRIVILEGES - EFFECTIVE_PRIVILEGES
EFFECTIVE PRIVILEGES - EFFECTIVE_ROLE_GRANTEES
EFFECTIVE PRIVILEGES - EFFECTIVE_ROLES
DATA MASKING
INTRODUCTION TO DATA MASKING IN HANA DB 2.0
Paid
Self paced
All Levels
English (US)
38
Rating 4.61 out of 5 (9 ratings in Udemy)
Go to the Course