How to change Page Authorization Scheme on runtime in Oracle APEX

   first 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;

--
thanks

How to change Authorization Scheme on runtime in Oracle APEX

  first make select list item  P4_AUTHORIZTION_SCHEMA

that will contain all Authorization available for your APP

 

use this code as source 

 

select a.d, a.r from (

    select APEX_200200.wwv_flow_lang.system_message('MUST_NOT_BE_PUBLIC_USER') d,'MUST_NOT_BE_PUBLIC_USER' r, 1 

    from dual

    union all

    select APEX_200200.wwv_flow_escape.html(substr(name,1,50)),to_char(id), 1

    from APEX_200200.wwv_flow_security_schemes where flow_id = :APP_ID

    union all

    select '{'||APEX_200200.wwv_flow_lang.system_message('NOT_W_ARGUMENT',APEX_200200.wwv_flow_escape.html(substr(name,1,50)))||'}' d,

     '!'||to_char(id) r, 2

    from   APEX_200200.wwv_flow_security_schemes

    where flow_id = :APP_ID

    order by 3,1) a

and make process to update Application Authorization 

UPDATE APEX_200200.wwv_flows 

SET SECURITY_SCHEME =:P4_AUTHORIZTION_SCHEMA

where ID = :APP_ID;

--
thanks

How to change Parsing Schema on runtime in Oracle APEX

  first 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 r

from   APEX_200200.wwv_flow_company_schemas

where  security_group_id = :flow_security_group_id

order by 1

and make process to update Application Authentication 

UPDATE APEX_200200.wwv_flows 

SET SECURITY_SCHEME =:P4_AUTHORIZTION_SCHEMA

where ID = :APP_ID;

--
thanks

How to change Authentication Schemes on runtime in Oracle APEX

 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;

--
thanks