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 STUDIOINTRODUCTION TO HANA STUDIO - ADMINISTRATION CONSOLEINTRODUCTION TO HANA STUDIO - PERSPECTIVESINTRODUCTION TO PRIVILEGESSYSTEM PRIVILEGESOBJECTPRIVILEGESANALYTIC PRIVILEGESPACKAGE PRIVILEGESAPPLICATION PRIVILEGESCATALOG OBJECTSOVERVIEWSCHEMASTABLESREPOSITORY OBJECTSSCHEMASTABLESUSER ACCOUNT ADMINISTRATIONOVERVIEWUSING SQL STATEMENTSUSING SAP HANA STUDIOUSING SAP HANA WEB IDEUSER VIEWSDELETING USERSCONVERTING USER IDs in HANA DBCONVERTING USER IDs in HANA DB - DEMO OF USING RESTRICTED USER IDGRANTING AND REVOKING PRIVILEGES - SYSTEM PRIVILEGES - SQL STATEMENTSGRANTING AND REVOKING PRIVILEGES - CATALOG SCHEMA - SQL STATEMENTSGRANTING AND REVOKING PRIVILEGES - REPOSITORY SCHEMA - SQL STATEMENTSGRANTING AND REVOKING PRIVILEGES - APPLICATION PRIVILEGES - SQL STATEMENTSGRANTING AND REVOKING PRIVILEGES - REPOSITORY ANALYTIC PRIVILEGES - SQL STATEMENTSGRANTING AND REVOKING PRIVILEGES - PACKAGE PRIVILEGES - SQL STATEMENTSGRANTING AND REVOKING PRIVILEGES - HANA STUDIOGRANTING AND REVOKING PRIVILEGES - WEB IDEGRANTING AND REVOKING ROLES - CATALOG ROLES - SQL STATEMENTGRANTING AND REVOKING ROLES - REPOSITORY ROLES - SQL STATEMENTGRANTING AND REVOKING ROLES - REPOSITORY ROLES - SAP HANA STUDIOGRANTING AND REVOKING ROLES - ROLES - SAP HANA WEB IDEDATABASE ROLESOVERVIEWCREATING AND DELETING ROLES - SQL STATEMENTSCREATING AND DELETING ROLES - SAP HANA STUDIOCREATING AND DELETING ROLES - SAP HANA WEB IDEGRANTING AND REVOKING PRIVILEGES - SYSTEM PRIVILEGES - USING SQL STATEMENTSGRANTING AND REVOKING PRIVILEGES - CATALOG SCHEMAS - USING SQL STATEMENTSGRANTING AND REVOKING PRIVILEGES - REPOSITORY SCHEMAS - USING SQL STATEMENTSGRANTING AND REVOKING PRIVILEGES - CATALOG OBJECTS - USING SQL STATEMENTSGRANTING AND REVOKING PRIVILEGES - REPOSITORY OBJECTS - USING SQL STATEMENTSGRANTING AND REVOKING PRIVILEGES - REPOSITORY ANALYTIC PRIVILEGES - USING SQL STATEMENTSGRANTING AND REVOKING PRIVILEGES - APPLICATION PRIVILEGES - USING SQL STATEMENTSGRANTING AND REVOKING PRIVILEGES - PACKAGE PRIVILEGES - USING SQL STATEMENTSGRANTING AND REVOKING PRIVILEGES - USING SAP HANA STUDIOGRANTING AND REVOKING PRIVILEGES - USING SAP WEB IDENESTED ROLESREPOSITORY ROLESOVERVIEWCREATING REPOSITORY ROLE - PART 01CREATING REPOSITORY ROLE - PART 02CREATING REPOSITORY ROLE - PART 03CREATING REPOSITORY ROLE - PART 04CREATING REPOSITORY ROLE - PART 05CREATING REPOSITORY ROLE - PART 06CREATING REPOSITORY ROLE - PART 07CREATING REPOSITORY ROLE - PART 08CREATING REPOSITORY ROLE - PART 09CREATING REPOSITORY ROLE - USING SAP HANA WEB IDEGRANTING REPOSITORY ROLES TO USERS - WITH STORED PROCEDURESGRANTING REPOSITORY ROLES TO USERS - WITH SAP HANA STUDIO AND WEB IDEREPOSITORY ROLES - SECURITY ADMINISTRATOR ROLEREPOSITORY ROLES - BASIS ADMINISTRATOR ROLESYSTEM PRIVILEGESRELATED TO DEVELOPMENTRELATED TO SECURITY ADMINISTRATIONRELATED TO SYSTEM ADMINISTRATIONGRANTING TO USERS AND STANDARD ROLESGRANTING TO REPOSITORY ROLESOBJECT PRIVILEGESOVERVIEWGRANTING AND REVOKING PRIVILEGES USING SQL STATEMENTSGRANTING AND REVOKING PRIVILEGES USING SAP HANA STUDIO AND WEB IDEGRANTING AND REVOKING PRIVILEGES USING REPOSITORY ROLESPACKAGE PRIVILEGESOVERVIEWGRANTING PACKAGE PRIVILEGES - USING SQLGRANTING PACKAGE PRIVILEGES - WITH SAP HANA STUDIO AND SAP HANA WEB IDEGRANTING PACKAGE PRIVILEGES - WITH REPOSITORY ROLESANALYTIC PRIVILEGESINFORMATION VIEWS - OVERVIEWCLASSICAL ANALYTIC PRIVILEGE - PART 1CLASSICAL ANALYTIC PRIVILEGE - PART 2CLASSICAL ANALYTIC PRIVILEGE - PART 3SQL ANALYTIC PRIVILEGE - PART 1SQL ANALYTIC PRIVILEGE - PART 2SQL ANALYTIC PRIVILEGE - PART 3DYNAMIC CLASSICAL ANALYTIC PRIVILEGE - PART 1DYNAMIC CLASSICAL ANALYTIC PRIVILEGE - PART 2DYNAMIC SQL ANALYTIC PRIVILEGE - PART 1DYNAMIC SQL ANALYTIC PRIVILEGE - PART 2GRANTING ANALYTIC PRIVILEGESGRANTING ANALYTIC PRIVILEGES USING REPOSITORY ROLEAUDITINGUSING HANA STUDIOUSING SAP HANA WEB IDEUSING SQL STATEMENTSQUERYING AUDIT DATATROUBLESHOOTINGTRACING USING SAP HANA STUDIOTRACING USING SQL STATEMENTSEFFECTIVE PRIVILEGES - GRANTED PRIVILEGESEFFECTIVE PRIVILEGES - GRANTED ROLESEFFECTIVE PRIVILEGES - ACCESSIBLE VIEWSEFFECTIVE PRIVILEGES - EFFECTIVE PRIVILEGE GRANTEESEFFECTIVE PRIVILEGES - EFFECTIVE STRUCTURED PRIVILEGESEFFECTIVE PRIVILEGES - EFFECTIVE PRIVILEGESEFFECTIVE PRIVILEGES - EFFECTIVE ROLE GRANTEESEFFECTIVE PRIVILEGES - EFFECTIVE ROLESDATA MASKINGINTRODUCTION TO DATA MASKING IN HANA DB 2.0
