Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Oracle Apex security fundamentals
Rating: 4.7 out of 5(19 ratings)
235 students

Oracle Apex security fundamentals

Arabic with subtitles
Created byMohsen Sleem
Last updated 4/2023
English

What you'll learn

  • Authentication concept
  • Authorization concept
  • how to build custom security application - custom Authentication
  • how to build custom security application - Authorization Schemes
  • how to build custom security application - password encryption methods
  • how to build custom security application - applying Authorization Schemes
  • how to build custom security application -how to avoid the user tricks to violate your security rules
  • Enhancing Security using Oracle DBMS_Crypto Package

Course content

1 section26 lectures1h 48m total length
  • what is authentication0:48

    Explore what authentication is and how authentication applies to applications within Oracle Apex security fundamentals.

  • what is authorization0:26

    Understand how authorization supports the user and is molded by the server itself. See how the server shapes authorization within Oracle Apex.

  • authentication scheme types 11:04

    Explore authentication scheme types in Oracle Apex security fundamentals, including no authentication, single sign-on, custom http header variables, and social sign-in for Oracle Apex and database accounts.

  • authentication scheme types 26:43

    Learn Oracle APEX security fundamentals by examining authentication scheme types, including default and pre-configured schemes, application express accounts, and custom and social sign-in options.

  • Define authorization schemes 17:15

    Define and manage point and predefined authorization schemes, configure access control roles such as administrator and reader, and govern users and groups in Oracle Apex security fundamentals.

  • Define authorization schemes 213:38

    Define and implement authorization schemes in Oracle APEX by building access control lists, assigning admin and reader roles, and validating users with SQL-based boolean checks.

  • change password5:26

    Explore secure password change workflows, including applying encryption to new passwords, managing admin passwords, and avoiding weak patterns such as 'one two three' in login and logout processes.

  • Reset password3:21
  • Enhancing Security using DBMS_Crypto Package lesson 10:51

    Enhance database security by learning the Oracle DBMS_Crypto package, including encryption and decryption commands, and applying Tamil encryption concepts within the security framework.

  • Enhancing Security using DBMS_Crypto Package lesson 21:33

    Enhance security with the DBMS_CRYPTO package by learning to encrypt and decrypt data, handle raw and binary values, varchar2 strings, and key management practices.

  • Enhancing Security using DBMS_Crypto Package lesson 31:11

    Explore how to use the dbms_crypto encrypt and decrypt functions, focusing on the des algorithm and secure data handling in Oracle APEX security fundamentals.

  • Enhancing Security using DBMS_Crypto Package lesson 42:02

    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.

  • Enhancing Security using DBMS_Crypto Package lesson 52:19

    Explore secure data handling with the DBMS_Crypto package, covering encryption and decryption, password hashing, and hash algorithms such as md4, md5, and sha1.

  • Enhancing Security using DBMS_Crypto Package lesson 65:37

    Explore how to enhance Oracle Apex security with the dbms_crypto package, including encryption and decryption workflows, algorithm choices, and hashing techniques.

  • Enhancing Security using DBMS_Crypto Package lesson 76:07

    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.

  • Enhancing Security using DBMS_Crypto Package lesson 82:23

    Explore how to enhance security in Oracle APEX by using the DBMS_Crypto package to encrypt passwords and manage encrypted values linked to user numbers and primary keys.

  • creating custom security application - course scripts2:11
  • creating custom security application lesson 10:58

    Create a custom security application by building an authorization function and a custom integration function, and implement access control for administrators and end users.

  • creating custom security application lesson 21:50

    Learn how to create a custom security application in Oracle APEX by designing and managing application database objects such as tables, sequences, and triggers.

  • creating custom security application lesson 31:16

    Create a custom security app modeling a users table with key user number, including username, password, role, and active status, with insert, update, and delete flags in a one-to-many relation.

  • creating custom security application lesson 44:40

    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.

  • creating custom security application lesson 58:53

    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.

  • creating custom security application lesson 61:23

    Explore implementing a custom authentication method in a security application, handling admin and end user roles, configuring password usage, and initiating sign-out functionality within an integration context.

  • creating custom security application lesson 712:23

    Create and manage a custom security interface in Oracle Apex by defining users with keys, editing master details, and applying login rules, popups, and SQL queries across application pages.

  • creating custom security application lesson 85:50

    Explore Oracle APEX security fundamentals by implementing and validating an authorization scheme, managing access control for ticketed users and admin roles, and performing insert, update, delete, and login operations.

  • creating custom security application lesson 98:12

    Learn to build a custom security application in Oracle Apex by creating, deleting, and updating processes, editing HTML, applying server-side validation, handling errors, and saving configurations with YAML.

Requirements

  • good knowledge of Oracle PL/SQL and basics of Oracle Apex

Description

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





Who this course is for:

  • oracle apex developers