
Explore what authentication is and how authentication applies to applications within Oracle Apex security fundamentals.
Learn how to use the dbms_crypto package to encrypt and decrypt data in Oracle APEX, including handling raw and binary values, and reinforcing security with keys and algorithms.
Practice building and compiling a DBMS_CRYPTO package, encrypt data with the package functions, decrypt to verify results, and explore hash functions and key management.
Learn how to create a custom security application in Oracle Apex, building authentication using username and password checks, pre-configured schemes, and a custom auth wrapper for robust access control.
Design and implement custom authorization and authentication in Oracle APEX, using PL/SQL boolean functions to control insert, update, delete, and query operations with user, role, and token-based access.
In this program, the student will be able to understand how to build a system for managing the privileges of the application by understanding the concepts of authentication and the concept of authorization and exposure to different types of authentications in addition to identifying the different types of authorization And learn how to build a page to change the password, as well as build a page for the system administrator to reset the password .
In this course, we will be exposed to the oracle dbms_crypto package and study the different methods of data encryption
Then the course directs the student towards building a custom security system based on the previous concepts
The course combines theoretical concepts and the practical application of these concepts in the form of a workshop that the student can implement to deepen the benefit of the course.
The course works in four stages
The first stage: studying the concepts of confidentiality
The second stage: apply these concepts by building an Oracle Apex application
The third stage is the study of encryption methods
Fourth stage: building a custom security system
The course is translated into English for greater use
In the end, I hope that I have provided good content that benefits APEX users and I will be happy to receive any feedback that enriches this content the course
this course conatins the following topics:
what is authentication
what is authorization
-authentication scheme types 1
-authentication scheme types 2
-Define authorization schemes 1
-Define authorization schemes 2
-change password
-Reset password
-Enhancing Security using DBMS_Crypto Package lesson 1
-Enhancing Security using DBMS_Crypto Package lesson 2
-Enhancing Security using DBMS_Crypto Package lesson 3
-Enhancing Security using DBMS_Crypto Package lesson 4
-Enhancing Security using DBMS_Crypto Package lesson 5
-Enhancing Security using DBMS_Crypto Package lesson 6
-Enhancing Security using DBMS_Crypto Package lesson 7
-Enhancing Security using DBMS_Crypto Package lesson 8
-creating custom security application - course scripts
-creating custom security application lesson 1
-creating custom security application lesson 2
-creating custom security application lesson 3
-creating custom security application lesson 4
-creating custom security application lesson 5
-creating custom security application lesson 6
-creating custom security application lesson 7
-creating custom security application lesson 8
-creating custom security application lesson 9