Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

Oracle APEX : Dynamic Security Module ( English subtitle)

Name: Oracle APEX : Dynamic Security Module ( English subtitle)
Rating: 4.2 (25 reviews)

Change Authentication ,Schema ,Authorization,Read only,Build Option and server side condtion on runtime in Oracle APEX

Highest Rated

Created byAli Saleh Ali

Last updated 6/2023

Arabic

What you'll learn

How to change Authentication Schemes on runtime
How to change DB Schemes on runtime
How to change Authorization on runtime
How to change Read Only on runtime
How to change Bulid Option on runtime
How to change Server side Condition on runtime

Course content

8 sections • 16 lectures • 1h 1m total length

Introduction2:19

change Authentication Schemes on runtime6:24
first make select list item P2_AUTHENTICATION_ID
that will contain all Authentication available for your APP
use this code as source

select name as d, id as r from APEX_200200.wwv_flow_authentications where flow_id = :APP_ID and security_group_id = :WORKSPACE_ID order by 1
and make process to update Application Authentication
UPDATE APEX_200200.wwv_flows
SET AUTHENTICATION_ID =:P2_AUTHENTICATION_ID
where ID = :APP_ID;

--
change Parsing Schema on runtime3:06

Make select list item
P4_AUTHORIZTION_SCHEMA
that will contain all DB schema available for your workspace
use this code as source

select APEX_200200.wwv_flow_escape.html(schema) d, schema rfrom APEX_200200.wwv_flow_company_schemaswhere security_group_id = :flow_security_group_idorder by 1
and make process to update Application Authentication
UPDATE APEX_200200.wwv_flows
SET SECURITY_SCHEME =:P4_AUTHORIZTION_SCHEMA
where ID = :APP_ID;
change Authorization Scheme on runtime4:24

change Page Authorization Scheme on runtime4:14
Make select list item P7_SECURITY_ID
that will contain all Authorization available for your APP
use this code as source

select NAME,ID from APEX_200200.wwv_flow_security_schemes where FLOW_ID =:P7_FLOW_ID
and make process to update Page Authorization

BEGIN
UPDATE APEX_200200.wwv_flow_steps -- PageS
SET required_role = :P7_SECURITY_ID -- Authorization schema
WHERE FLOW_ID = :P7_FLOW_ID -- APP ID
and ID = :P7_STEP_ID -- PAGE ID;
end;
change Page to Public or Not on runtime3:47
Make select list item P7_PAGE_IS_PUBLIC_Y_N
YES :Y
No :N
and make process to change Page to Public or Not
BEGIN
UPDATE APEX_200200.wwv_flow_steps -- Pages
SET PAGE_IS_PUBLIC_Y_N = :P7_PAGE_IS_PUBLIC_Y_N
WHERE FLOW_ID = :P7_FLOW_ID -- APP ID
and ID = :P7_STEP_ID -- PAGE ID;
end;
change Page Read Only on runtime3:29
Make process to change Page Read only on runtime

BEGIN
UPDATE APEX_200200.wwv_flow_steps -- Pages
SET READ_ONLY_WHEN_TYPE = 'EXISTS' ,
READ_ONLY_WHEN = 'select 1 from dual where 1=1'
WHERE FLOW_ID = :P7_FLOW_ID -- APP ID
and ID = :P7_STEP_ID -- PAGE ID;
end;

--

thanks
change Build Option for Page on runtime4:25
Make select list item P7_BUILD_OPTION
that will contain all Build Option available for your APP
use this code as source

select patch_name||' ('||wwv_flow_lang.system_message(patch_status)||')' d, id r from APEX_200200.wwv_flow_patches where FLOW_ID = :APP_ID;

and make process to update Page Build Option

BEGIN
UPDATE APEX_200200.wwv_flow_steps
SET REQUIRED_PATCH = :P7_BUILD_OPTION
WHERE FLOW_ID = :P7_FLOW_ID
and ID = :P7_STEP_ID ;
end;

change Region Authorization Scheme on runtime3:12
Make P6_REGION_ID
that will contain all Region available for your page
use this code as source
select
PLUG_NAME,
ID
from APEX_200200.wwv_flow_page_plugs
where FLOW_ID =:P6_FLOW_ID
and PAGE_ID =:P6_STEP_ID
and select list item P6_SECURITY_ID
that will contain all Authorization available for your APP
use this code as source

select NAME,ID from APEX_200200.wwv_flow_security_schemes where FLOW_ID =:P7_FLOW_ID
and make process to update Region Authorization
BEGIN
UPDATE APEX_200200.wwv_flow_page_plugs
SET PLUG_REQUIRED_ROLE = :P6_SECURITY_ID
WHERE FLOW_ID = :P6_FLOW_ID
and PAGE_ID = :P6_STEP_ID
and ID = :P6_REGION_ID
end;
--
change Region Bulid Option on runtime2:47
Make P6_REGION_ID
that will contain all Region available for your page
use this code as source
select
PLUG_NAME,
ID
from APEX_200200.wwv_flow_page_plugs
where FLOW_ID =:P6_FLOW_ID
and PAGE_ID =:P6_STEP_ID

and select list item P6_BUILD_OPTION
that will contain all build Option available for your APP
use this code as source

select PATCH_NAME,ID from APEX_200200.wwv_flow_patches where FLOW_ID =:P6_FLOW_ID
and make process to update Region Build Option
BEGIN
UPDATE APEX_200200.wwv_flow_page_plugs -- Region
SET REQUIRED_PATCH = :P6_BUILD_OPTION
WHERE FLOW_ID = :P6_FLOW_ID -- APP ID
and PAGE_ID = :P6_STEP_ID -- PAGE ID
and ID = :P6_REGION_ID -- REGION ID;
end;
change Region Server Side Condition on runtime2:56
Make P6_REGION_ID
that will contain all Region available for your page
use this code as source
select
PLUG_NAME,
ID
from APEX_200200.wwv_flow_page_plugs
where FLOW_ID =:P6_FLOW_ID
and PAGE_ID =:P6_STEP_ID
and make process to update Region Server side condition
BEGIN
UPDATE APEX_200200.wwv_flow_page_plugs -- Region
SET PLUG_DISPLAY_CONDITION_TYPE = 'NOT_EXISTS' ,
PLUG_DISPLAY_WHEN_CONDITION = 'SELECT 1 from dual where 1=2'
WHERE FLOW_ID = :P6_FLOW_ID -- APP ID
and PAGE_ID = :P6_STEP_ID -- PAGE ID
and ID = :P6_REGION_ID -- REGION ID;
end;
change Region read only on runtime2:27
Make P6_REGION_ID
that will contain all Region available for your page
use this code as source
select
PLUG_NAME,
ID
from APEX_200200.wwv_flow_page_plugs
where FLOW_ID =:P6_FLOW_ID
and PAGE_ID =:P6_STEP_ID
and make process to update Region read only
BEGIN
UPDATE APEX_200200.wwv_flow_page_plugs -- Region
SET PLUG_READ_ONLY_WHEN_TYPE = 'EXISTS' ,
PLUG_READ_ONLY_WHEN = 'SELECT 1 from dual where 1 =2 '
WHERE FLOW_ID = :P6_FLOW_ID -- APP ID
and PAGE_ID = :P6_STEP_ID -- PAGE ID
and ID = :P6_REGION_ID -- REGION ID;
end;

Change Authorization, Build Option ,Read only and Server side for Item5:35
Make Item for Items
select NAME,ID from APEX_200200.wwv_flow_step_items
where FLOW_ID = :P9_FLOW_ID
and FLOW_STEP_ID =:P9_STEP_ID
and ITEM_PLUG_ID =:P9_REGION_ID
Process for Autharization
BEGIN
UPDATE APEX_200200.wwv_flow_step_items -- ITEMS
SET SECURITY_SCHEME = :P9_SECURITY_ID -- Authorization schema
WHERE FLOW_ID = :P9_FLOW_ID -- APP ID
and FLOW_STEP_ID = :P9_STEP_ID -- PAGE ID
and ITEM_PLUG_ID =:P9_REGION_ID -- region region
and ID = :P9_ITEM_ID; -- item id
end;

Process for Build Option
BEGIN
UPDATE APEX_200200.wwv_flow_step_items -- Region
SET REQUIRED_PATCH = :P9_BUILD_OPTION
WHERE FLOW_ID = :P9_FLOW_ID -- APP ID
and FLOW_STEP_ID = :P9_STEP_ID -- PAGE ID
and ITEM_PLUG_ID =:P9_REGION_ID -- region region
and ID = :P9_ITEM_ID; -- item id
end;

Process for Read only
BEGIN
UPDATE APEX_200200.wwv_flow_step_items -- ITEMS
SET READ_ONLY_WHEN_TYPE = 'EXISTS',
READ_ONLY_WHEN ='select 1 from dual'
WHERE FLOW_ID = :P9_FLOW_ID -- APP ID
and FLOW_STEP_ID = :P9_STEP_ID -- PAGE ID
and ITEM_PLUG_ID =:P9_REGION_ID -- region region
and ID = :P9_ITEM_ID; -- item id
end;
Process for Server side condtion
BEGIN
UPDATE APEX_200200.wwv_flow_step_items -- ITEMS
SET DISPLAY_WHEN_TYPE = 'EXISTS',
DISPLAY_WHEN ='select 1 from dual where 1=2'
WHERE FLOW_ID = :P9_FLOW_ID -- APP ID
and FLOW_STEP_ID = :P9_STEP_ID -- PAGE ID
and ITEM_PLUG_ID =:P9_REGION_ID -- region region
and ID = :P9_ITEM_ID; -- item id
end;

Change Autharization, Build Option ,custom attribute and Server side for button4:52
Make Item for process
select PROCESS_NAME,ID from APEX_200200.wwv_flow_step_processing
where FLOW_ID = :P10_FLOW_ID
and FLOW_STEP_ID =:P10_STEP_ID
Process for Autharization
BEGIN
UPDATE APEX_200200.wwv_flow_step_processing -- Process table
SET SECURITY_SCHEME = :P10_SECURITY_ID -- Authorization schema
WHERE FLOW_ID = :P10_FLOW_ID -- APP ID
and FLOW_STEP_ID = :P10_STEP_ID -- PAGE ID
and ID = :P10_PROCESS_ID; -- process id
end;
Process for process point
BEGIN
UPDATE APEX_200200.wwv_flow_step_processing -- Process table
SET PROCESS_POINT = 'BEFORE_HEADER' -- PROCESS POINT
WHERE FLOW_ID = :P10_FLOW_ID -- APP ID
and FLOW_STEP_ID = :P10_STEP_ID -- PAGE ID
and ID = :P10_PROCESS_ID; -- process id
end;

Process for assigned button
BEGIN
UPDATE APEX_200200.wwv_flow_step_processing -- Process table
SET PROCESS_WHEN_BUTTON_ID = :P10_BUTTON_ID --when button
WHERE FLOW_ID = :P10_FLOW_ID -- APP ID
and FLOW_STEP_ID = :P10_STEP_ID -- PAGE ID
and ID = :P10_PROCESS_ID; -- process id
end;

Change Autharization, boint and assigned button for Process4:14
Make Item for process
select PROCESS_NAME,ID from APEX_200200.wwv_flow_step_processing
where FLOW_ID = :P10_FLOW_ID
and FLOW_STEP_ID =:P10_STEP_ID

Process for Autharization
BEGIN
UPDATE APEX_200200.wwv_flow_step_processing -- Process table
SET SECURITY_SCHEME = :P10_SECURITY_ID -- Authorization schema
WHERE FLOW_ID = :P10_FLOW_ID -- APP ID
and FLOW_STEP_ID = :P10_STEP_ID -- PAGE ID
and ID = :P10_PROCESS_ID; -- process id
end;

Process for process point
BEGIN
UPDATE APEX_200200.wwv_flow_step_processing -- Process table
SET PROCESS_POINT = 'BEFORE_HEADER' -- PROCESS POINT
WHERE FLOW_ID = :P10_FLOW_ID -- APP ID
and FLOW_STEP_ID = :P10_STEP_ID -- PAGE ID
and ID = :P10_PROCESS_ID; -- process id
end;

Process for assigned button
BEGIN
UPDATE APEX_200200.wwv_flow_step_processing -- Process table
SET PROCESS_WHEN_BUTTON_ID = :P10_BUTTON_ID --when button
WHERE FLOW_ID = :P10_FLOW_ID -- APP ID
and FLOW_STEP_ID = :P10_STEP_ID -- PAGE ID
and ID = :P10_PROCESS_ID; -- process id
end;

Requirements

Oracle APEX
SQL
PL/SQL

Description

Authentication

Authentication is the process of establishing each user's identify before they can access your application. You may define multiple authentication schemes for your application, however only one scheme can be current. The authentication logic of the current scheme is used when your application is run.

Authorization

Application authorization schemes control access to all pages within an application. Unauthorized access to the application, regardless of which page is requested, will cause an error page to be displayed.

How to change Authentication Schemes on runtime in Oracle APEX

How to change Parsing Schema on runtime in Oracle APEX

How to change Authorization Scheme on runtime in Oracle APEX

How to change Page Authorization Scheme on runtime in Oracle APEX

How to change Page to Public or Not on runtime in Oracle APEX

How to change Page Read only on runtime in Oracle APEX

How to change Page Build Option on runtime in Oracle APEX

How to change Region Authorization Scheme on runtime in Oracle APEX

How to change Region Read only on runtime in Oracle APEX

How to change Region Build Option on runtime in Oracle APEX

How to change Region server side condition on runtime in Oracle APEX

How to change item Authorization Scheme, Read only, Build Option and server side condition on runtime in Oracle APEX

How to change Button Authorization Scheme, Build Option and server side condition on runtime in Oracle APEX

How to change Process Authorization Scheme, Build Option,asign button and server side condition on runtime in Oracle APEX

How to change Dynamic action Authorization Scheme, Build Option and server side condition on runtime in Oracle APEX

Who this course is for:

Beginner Oracle APEX developers

Oracle APEX : Dynamic Security Module ( English subtitle)

What you'll learn

Explore related topics

Course content

Introduction1 lecture • 2min

Application Level3 lectures • 14min

Page Level4 lectures • 16min

Region Level4 lectures • 11min

Item Level1 lecture • 6min

button Level1 lecture • 5min

Process Level1 lecture • 4min

Dynamic action Level1 lecture • 4min

Requirements

Description

Who this course is for: