PROBLEM
I find periodically that when I create a new Application that I get the following error message;
You are not authorized to view this application, either because you have not been granted access, or your account has been locked. Please contact the application administrator.
Access denied by Application security check
Technical Info (only available for developers)
is_internal_error: true
apex_error_code: APEX.AUTHORIZATION.ACCESS_DENIED
component.type: APEX_APPLICATION_AUTHORIZATION
component.id: 9920380350918196
component.name: Reader Rights
error_backtrace:----- PL/SQL Call Stack ----- object line object handle number name 0x31a621780 1016 package body APEX_230200.WWV_FLOW_ERROR.INTERNAL_GET_ERROR 0x31a621780 1085 package body APEX_230200.WWV_FLOW_ERROR.INTERNAL_ADD_ERROR 0x31a621780 1569 package body APEX_230200.WWV_FLOW_ERROR.RAISE_INTERNAL_ERROR 0x84ab30ea0 962 package body APEX_230200.WWV_FLOW_AUTHORIZATION.IS_AUTHORIZED 0x67ada5d68 2937 package body APEX_230200.WWV_FLOW.SHOW 0x67ada5d68 5490 package body APEX_230200.WWV_FLOW.RESOLVE_FRIENDLY_URL 0x1a6b344a0 2 anonymous block
BACKGROUND INFO
The user ID is for the Administrator.
I have tried the following
- Create a new user from within the Application (ie … Administration > Manage Users and Groupd > [Create User]…)
- Create a new user from Administration access on login screen (ie … Administration > Manage Workspaces > Manage Developers and Users > [Create User]…)
I see a solution to this problem on Oracle.Com is to use steps in https://docs.oracle.com/en/database/oracle/application-express/20.2/aeapi/APEX_ACL.html#GUID-C59214CB-8138-4CB4-89CC-4CC357A67288. However I am not able to find how to do this in OCI.
I have also noted in some cases the problem goes away without any changes after about 24 hours / overnight. This time it has not.
REQUEST
- Can anyone explain why this problem exists?
- How to resolve the problem?
Thanks
Scott