|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/saphanadbsecuritymadeeasy/
课程评论:没有评论
本课程“SAP HANA DB 安全入门”旨在通过 100 多个简短且直观的视频,帮助学员掌握 SAP HANA DB 2.0 的安全性。课程内容围绕 SAP HANA Studio、HANA Studio 管理控制台、权限(系统、对象、分析、包、应用程序)、目录对象、用户账户管理、角色(数据库角色、嵌套角色、存储库角色)以及审计和数据掩蔽等核心安全概念展开。 课程详细介绍了如何使用 SQL、SAP HANA Studio 和 SAP HANA Web IDE 来创建、授予和撤销各种权限和角色。重点包括对存储库角色、系统权限、对象权限、包权限和分析权限的深入讲解,并涵盖了如何使用审计功能进行安全监控和故障排除。此外,课程还介绍了数据掩蔽的入门知识。 通过将每个主题分解成多个短视频,课程确保了学习的便捷性和高效性,使学员能够轻松理解和应用 SAP HANA DB 的安全管理技能。
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 PRIVILEGESOBJECT PRIVILEGESANALYTIC 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