Please update your forum profile with a recognisable username instead of "user12137935": Video tutorial how to change nickname available
Always include the information detailed in these guidelines when asking a question so we can provide version- and environment-specific information: how to get answers from forum
How to enable/disable the application from backend ? I would like to disable the application from back end while running some purging scripts and once finished make it available for users. Is it achievable ?
Set the application's availability status in the application attributes to Restricted or Unavailable...
Apex Version: APEX 4.2.6.00.03
Oracle Database 12c Enterprise Edition Release 220.127.116.11.0 - 64bit
ORDS version 2.0.9.
I would like to control this availability status from back end oracle procedure not from the front end APEX tool. Hope it clarifies.
The following code can be found using SQL Developer
declare PRAGMA AUTONOMOUS_TRANSACTION; begin wwv_flow_api.set_security_group_id(p_security_group_id=>1317622345803862); wwv_flow_api.set_flow_status (p_flow_id=>210,p_flow_status=>'UNAVAILABLE'); commit; end;
As per documentation regarding Availability
An alternative is to use the verify function in the authentication scheme, and redirect users to your own destination, on you own terms, for anyone who navigates in your application.
Thank you very much. It works for me.