SAP HANA DB Security Made Easy

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

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

1. INTRODUCTION TO HANA STUDIO - ADMINISTRATION CONSOLE

2. INTRODUCTION TO HANA STUDIO - PERSPECTIVES

INTRODUCTION TO PRIVILEGES

1. SYSTEM PRIVILEGES

2. OBJECTPRIVILEGES

3. ANALYTIC PRIVILEGES

4. PACKAGE PRIVILEGES

5. APPLICATION PRIVILEGES

CATALOG OBJECTS

1. OVERVIEW

2. SCHEMAS

3. TABLES

REPOSITORY OBJECTS

1. SCHEMAS

2. TABLES

USER ACCOUNT ADMINISTRATION

1. OVERVIEW

2. USING SQL STATEMENTS

3. USING SAP HANA STUDIO

4. USING SAP HANA WEB IDE

5. USER VIEWS

6. DELETING USERS

7. CONVERTING USER IDs in HANA DB

8. CONVERTING USER IDs in HANA DB - DEMO OF USING RESTRICTED USER ID

9. GRANTING AND REVOKING PRIVILEGES - SYSTEM PRIVILEGES - SQL STATEMENTS

10. GRANTING AND REVOKING PRIVILEGES - CATALOG SCHEMA - SQL STATEMENTS

11. GRANTING AND REVOKING PRIVILEGES - REPOSITORY SCHEMA - SQL STATEMENTS

12. GRANTING AND REVOKING PRIVILEGES - APPLICATION PRIVILEGES - SQL STATEMENTS

13. GRANTING AND REVOKING PRIVILEGES - REPOSITORY ANALYTIC PRIVILEGES - SQL STATEMENTS

14. GRANTING AND REVOKING PRIVILEGES - PACKAGE PRIVILEGES - SQL STATEMENTS

15. GRANTING AND REVOKING PRIVILEGES - HANA STUDIO

16. GRANTING AND REVOKING PRIVILEGES - WEB IDE

17. GRANTING AND REVOKING ROLES - CATALOG ROLES - SQL STATEMENT

18. GRANTING AND REVOKING ROLES - REPOSITORY ROLES - SQL STATEMENT

19. GRANTING AND REVOKING ROLES - REPOSITORY ROLES - SAP HANA STUDIO

20. GRANTING AND REVOKING ROLES - ROLES - SAP HANA WEB IDE

DATABASE ROLES

1. OVERVIEW

2. CREATING AND DELETING ROLES - SQL STATEMENTS

3. CREATING AND DELETING ROLES - SAP HANA STUDIO

4. CREATING AND DELETING ROLES - SAP HANA WEB IDE

5. GRANTING AND REVOKING PRIVILEGES - SYSTEM PRIVILEGES - USING SQL STATEMENTS

6. GRANTING AND REVOKING PRIVILEGES - CATALOG SCHEMAS - USING SQL STATEMENTS

7. GRANTING AND REVOKING PRIVILEGES - REPOSITORY SCHEMAS - USING SQL STATEMENTS

8. GRANTING AND REVOKING PRIVILEGES - CATALOG OBJECTS - USING SQL STATEMENTS

9. GRANTING AND REVOKING PRIVILEGES - REPOSITORY OBJECTS - USING SQL STATEMENTS

10. GRANTING AND REVOKING PRIVILEGES - REPOSITORY ANALYTIC PRIVILEGES - USING SQL STATEMENTS

11. GRANTING AND REVOKING PRIVILEGES - APPLICATION PRIVILEGES - USING SQL STATEMENTS

12. GRANTING AND REVOKING PRIVILEGES - PACKAGE PRIVILEGES - USING SQL STATEMENTS

13. GRANTING AND REVOKING PRIVILEGES - USING SAP HANA STUDIO

14. GRANTING AND REVOKING PRIVILEGES - USING SAP WEB IDE

15. NESTED ROLES

REPOSITORY ROLES

1. OVERVIEW

2. CREATING REPOSITORY ROLE - PART 01

3. CREATING REPOSITORY ROLE - PART 02

4. CREATING REPOSITORY ROLE - PART 03

5. CREATING REPOSITORY ROLE - PART 04

6. CREATING REPOSITORY ROLE - PART 05

7. CREATING REPOSITORY ROLE - PART 06

8. CREATING REPOSITORY ROLE - PART 07

9. CREATING REPOSITORY ROLE - PART 08

10. CREATING REPOSITORY ROLE - PART 09

11. CREATING REPOSITORY ROLE - USING SAP HANA WEB IDE

12. GRANTING REPOSITORY ROLES TO USERS - WITH STORED PROCEDURES

13. GRANTING REPOSITORY ROLES TO USERS - WITH SAP HANA STUDIO AND WEB IDE

14. REPOSITORY ROLES - SECURITY ADMINISTRATOR ROLE

15. REPOSITORY ROLES - BASIS ADMINISTRATOR ROLE

SYSTEM PRIVILEGES

1. RELATED TO DEVELOPMENT

2. RELATED TO SECURITY ADMINISTRATION

3. RELATED TO SYSTEM ADMINISTRATION

4. GRANTING TO USERS AND STANDARD ROLES

5. GRANTING TO REPOSITORY ROLES

OBJECT PRIVILEGES

1. OVERVIEW

2. GRANTING AND REVOKING PRIVILEGES USING SQL STATEMENTS

3. GRANTING AND REVOKING PRIVILEGES USING SAP HANA STUDIO AND WEB IDE

4. GRANTING AND REVOKING PRIVILEGES USING REPOSITORY ROLES

PACKAGE PRIVILEGES

1. OVERVIEW

2. GRANTING PACKAGE PRIVILEGES - USING SQL

3. GRANTING PACKAGE PRIVILEGES - WITH SAP HANA STUDIO AND SAP HANA WEB IDE

4. GRANTING PACKAGE PRIVILEGES - WITH REPOSITORY ROLES

ANALYTIC PRIVILEGES

1. INFORMATION VIEWS - OVERVIEW

2. CLASSICAL ANALYTIC PRIVILEGE - PART 1

3. CLASSICAL ANALYTIC PRIVILEGE - PART 2

4. CLASSICAL ANALYTIC PRIVILEGE - PART 3

5. SQL ANALYTIC PRIVILEGE - PART 1

6. SQL ANALYTIC PRIVILEGE - PART 2

7. SQL ANALYTIC PRIVILEGE - PART 3

8. DYNAMIC CLASSICAL ANALYTIC PRIVILEGE - PART 1

9. DYNAMIC CLASSICAL ANALYTIC PRIVILEGE - PART 2

10. DYNAMIC SQL ANALYTIC PRIVILEGE - PART 1

11. DYNAMIC SQL ANALYTIC PRIVILEGE - PART 2

12. GRANTING ANALYTIC PRIVILEGES

13. GRANTING ANALYTIC PRIVILEGES USING REPOSITORY ROLE

AUDITING

1. USING HANA STUDIO

2. USING SAP HANA WEB IDE

3. USING SQL STATEMENTS

4. QUERYING AUDIT DATA

TROUBLESHOOTING

1. TRACING USING SAP HANA STUDIO

2. TRACING USING SQL STATEMENTS

3. EFFECTIVE PRIVILEGES - GRANTED_PRIVILEGES

4. EFFECTIVE PRIVILEGES - GRANTED_ROLES

5. EFFECTIVE PRIVILEGES - ACCESSIBLE_VIEWS

6. EFFECTIVE PRIVILEGES - EFFECTIVE_PRIVILEGE_GRANTEES

7. EFFECTIVE PRIVILEGES - EFFECTIVE_STRUCTURED_PRIVILEGES

8. EFFECTIVE PRIVILEGES - EFFECTIVE_PRIVILEGES

9. EFFECTIVE PRIVILEGES - EFFECTIVE_ROLE_GRANTEES

10. EFFECTIVE PRIVILEGES - EFFECTIVE_ROLES

DATA MASKING

1. INTRODUCTION TO DATA MASKING IN HANA DB 2.0