UPDATES: *********** ISSUE FIX BY REMOVEING PROXY IN APP DEFINITIONS LEFT THERE FROM APEX.ORACLE.COM USAGE*****
UPDATES: *********** ISSUE FIX BY REMOVEING PROXY IN APP DEFINITIONS LEFT THERE FROM APEX.ORACLE.COM USAGE*****
UPDATES: *********** ISSUE FIX BY REMOVEING PROXY IN APP DEFINITIONS LEFT THERE FROM APEX.ORACLE.COM USAGE*****
UPDATES: *********** ISSUE FIX BY REMOVEING PROXY IN APP DEFINITIONS LEFT THERE FROM APEX.ORACLE.COM USAGE*****
UPDATES: *********** ISSUE FIX BY REMOVEING PROXY IN APP DEFINITIONS LEFT THERE FROM APEX.ORACLE.COM USAGE*****
UPDATES: *********** ISSUE FIX BY REMOVEING PROXY IN APP DEFINITIONS LEFT THERE FROM APEX.ORACLE.COM USAGE*****
I am running on oracle oci cloud Application Express 21.1.7
possibly the issue is with the call to
https://gd49ef7d5e3cd2d-db202110212330.adb.us-phoenix-1.oraclecloudapps.com/ords/wwv_flow.accept
When I run the local rest data "load data", I get
ORA-01031: insufficient privileges
Contact your application administrator. Details about this incident are available via debug id "57028".
Technical Info (only visible for developers)
UPDATES: *********** ISSUE FIX BY REMOVEING PROXY IN APP DEFINITIONS LEFT THERE FROM APEX.ORACLE.COM USAGE*****
Error Message |
User |
Page |
DateDescending |
ORA-01031: insufficient privileges Contact your application administrator. Details about this incident are available via debug id "57030". |
APLASCENCIA |
11 |
69 seconds ago |
APEX - ORA-01031: insufficient privileges - Contact your application administrator. Details about this incident are available via debug id "57029". ORA-06512: at "APEX_210100.WWV_FLOW_ERROR", line 1384 ORA-06512: at "APEX_210100.WWV_FLOW_ERROR", line 1419 |
APLASCENCIA |
2 |
96 seconds ago |
APEX - ORA-01031: insufficient privileges - Contact your application administrator. Details about this incident are available via debug id "57028". ORA-06512: at "APEX_210100.WWV_FLOW_ERROR", line 1384 ORA-06512: at "APEX_210100.WWV_FLOW_ERROR", line 1419 |
|
|
|
[Error Message]()
User
Page
DateDescending
ORA-01031: insufficient privileges Contact your application administrator. Details about this incident are available via debug id "57030". APLASCENCIA 11 69 seconds ago
APEX - ORA-01031: insufficient privileges - Contact your application administrator. Details about this incident are available via debug id "57029". ORA-06512: at "APEX_210100.WWV_FLOW_ERROR", line 1384 ORA-06512: at "APEX_210100.WWV_FLOW_ERROR", line 1419 APLASCENCIA 2 96 seconds ago
APEX - ORA-01031: insufficient privileges - Contact your application administrator. Details about this incident are available via debug id "57028". ORA-06512: at "APEX_210100.WWV_FLOW_ERROR", line 1384 ORA-06512: at "APEX_210100.WWV_FLOW_ERROR", line 1419
is_internal_error: false
ora_sqlcode: -1031
ora_sqlerrm: ORA-01031: insufficient privileges ORA-06512: at "APEX_210100.WWV_FLOW_PROCESS_NATIVE", line 56
ORA-06512: at "APEX_210100.WWV_FLOW_CODE_EXEC_PLSQL", line 124 ORA-06512: at "APEX_210100.WWV_FLOW_DYNAMIC_EXEC", line 2387 ORA-06512: at "APEX_210100.WWV_FLOW_WEB_SERVICES", line 1157 ORA-06512: at "APEX_210100.WWV_FLOW_WEB_SERVICES", line 757 ORA-06512: at "SYS.UTL_HTTP", line 20 ORA-06512: at "APEX_210100.WWV_FLOW_WEB_SERVICES", line 728 ORA-06512: at "APEX_210100.WWV_FLOW_WEB_SERVICES", line 998 ORA-06512: at "APEX_210100.WWV_FLOW_WEB_SERVICES", line 1346 ORA-06512: at "APEX_210100.WWV_FLOW_WEBSERVICES_API", line 604 ORA-06512: at line 5 ORA-06512: at "SYS.DBMS_SYS_SQL", line 2120 ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_210100", line 682 ORA-06512: at "APEX_210100.WWV_FLOW_DYNAMIC_EXEC", line 2348 ORA-06512: at "APEX_210100.WWV_FLOW_CODE_EXEC_PLSQL", line 96 ORA-06512: at "APEX_210100.WWV_FLOW_CODE_EXEC_PLSQL", line 330 ORA-06512: at "APEX_210100.WWV_FLOW_CODE_EXEC", line 394 ORA-06512: at "APEX_210100.WWV_FLOW_EXEC_LOCAL", line 2880 ORA-06512: at "APEX_210100.WWV_FLOW_EXEC", line 4434 ORA-06512: at "APEX_210100.WWV_FLOW_EXEC", line 4470 ORA-06512: at "APEX_210100.WWV_FLOW_PROCESS_NATIVE", line 35 ORA-06512: at "APEX_210100.WWV_FLOW_PROCESS_NATIVE", line 1116 ORA-06512: at "APEX_210100.WWV_FLOW_PLUGIN", line 2784
component.type: APEX_APPLICATION_PAGE_PROCESS
component.id: 1934813666072611847
component.name: Fetch data into Collection
error_backtrace:
ORA-06512: at "APEX_210100.WWV_FLOW_WEB_SERVICES", line 1157
ORA-06512: at "APEX_210100.WWV_FLOW_WEB_SERVICES", line 757
ORA-06512: at "SYS.UTL_HTTP", line 20
ORA-06512: at "APEX_210100.WWV_FLOW_WEB_SERVICES", line 728
ORA-06512: at "APEX_210100.WWV_FLOW_WEB_SERVICES", line 998
ORA-06512: at "APEX_210100.WWV_FLOW_WEB_SERVICES", line 1346
ORA-06512: at "APEX_210100.WWV_FLOW_WEBSERVICES_API", line 604
ORA-06512: at line 5
ORA-06512: at "SYS.DBMS_SYS_SQL", line 2120
ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_210100", line 682
ORA-06512: at "APEX_210100.WWV_FLOW_DYNAMIC_EXEC", line 2348
ORA-06512: at "APEX_210100.WWV_FLOW_PROCESS_NATIVE", line 56
ORA-06512: at "APEX_210100.WWV_FLOW_CODE_EXEC_PLSQL", line 124
ORA-06512: at "APEX_210100.WWV_FLOW_DYNAMIC_EXEC", line 2387
ORA-06512: at "APEX_210100.WWV_FLOW_WEB_SERVICES", line 1157
ORA-06512: at "APEX_210100.WWV_FLOW_WEB_SERVICES", line 757
ORA-06512: at "SYS.UTL_HTTP", line 20
ORA-06512: at "APEX_210100.WWV_FLOW_WEB_SERVICES", line 728
ORA-06512: at "APEX_210100.WWV_FLOW_WEB_SERVICES", line 998
ORA-06512: at "APEX_210100.WWV_FLOW_WEB_SERVICES", line 1346
ORA-06512: at "APEX_210100.WWV_FLOW_WEBSERVICES_API", line 604
ORA-06512: at line 5
ORA-06512: at "SYS.DBMS_SYS_SQL", line 2120
ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_210100", line 682
ORA-06512: at "APEX_210100.WWV_FLOW_DYNAMIC_EXEC", line 2348
ORA-06512: at "APEX_210100.WWV_FLOW_CODE_EXEC_PLSQL", line 96
ORA-06512: at "APEX_210100.WWV_FLOW_CODE_EXEC_PLSQL", line 330
ORA-06512: at "APEX_210100.WWV_FLOW_CODE_EXEC", line 394
ORA-06512: at "APEX_210100.WWV_FLOW_EXEC_LOCAL", line 2880
ORA-06512: at "APEX_210100.WWV_FLOW_EXEC", line 4434
ORA-06512: at "APEX_210100.WWV_FLOW_EXEC", line 4470
ORA-06512: at "APEX_210100.WWV_FLOW_PROCESS_NATIVE", line 35
ORA-06512: at "APEX_210100.WWV_FLOW_PROCESS_NATIVE", line 1116
ORA-06512: at "APEX_210100.WWV_FLOW_PLUGIN", line 2784
ORA-06512: at "APEX_210100.WWV_FLOW_PROCESS", line 203
error_statement:
begin declare
l_response clob;
begin
-- load REST response into a collection
l_response := apex_web_service.make_rest_request(
p_url => :SAMPLE_ENDPOINT_URL,
p_http_method => 'GET');
apex_collection.create_or_truncate_collection( 'REST_COLLECTION' );
apex_collection.add_member(
p_collection_name => 'REST_COLLECTION',
p_clob001 => l_response );
end;
end;
----------- here is the acl's -------------
CREATE OR REPLACE EDITIONABLE PROCEDURE "ADMIN"."SHOW_ACLS" AS
--DECLARE
l_last_acl dba_network_acls.acl%TYPE := '';
l_last_principal dba_network_acl_privileges.principal%TYPE := '';
l_last_privilege dba_network_acl_privileges.privilege%TYPE := '';
l_last_host dba_network_acls.host%TYPE := '';
FUNCTION get_timestamp (p_timestamp IN TIMESTAMP WITH TIME ZONE)
RETURN VARCHAR2
AS
l_return VARCHAR2(32767);
BEGIN
IF p_timestamp IS NULL THEN
RETURN 'NULL';
END IF;
RETURN 'TO_TIMESTAMP_TZ(''' || TO_CHAR(p_timestamp, 'DD-MON-YYYY HH24:MI:SS.FF TZH:TZM') || ''',''DD-MON-YYYY HH24:MI:SS.FF TZH:TZM'')';
END;
BEGIN
FOR i IN (SELECT a.acl,
a.host,
a.lower_port,
a.upper_port,
b.principal,
b.privilege,
b.is_grant,
b.start_date,
b.end_date
FROM dba_network_acls a
JOIN dba_network_acl_privileges b ON a.acl = b.acl
ORDER BY a.acl, a.host, a.lower_port, a.upper_port)
LOOP
IF l_last_acl <> i.acl THEN
-- First time we've seen this ACL, so create a new one.
l_last_host := '~';
DBMS_OUTPUT.put_line('-- -------------------------------------------------');
DBMS_OUTPUT.put_line('-- ' || i.acl);
DBMS_OUTPUT.put_line('-- -------------------------------------------------');
DBMS_OUTPUT.put_line('BEGIN');
DBMS_OUTPUT.put_line(' DBMS_NETWORK_ACL_ADMIN.drop_acl (');
DBMS_OUTPUT.put_line(' acl => ''' || i.acl || ''');');
DBMS_OUTPUT.put_line(' COMMIT;');
DBMS_OUTPUT.put_line('END;');
DBMS_OUTPUT.put_line('/');
DBMS_OUTPUT.put_line(' ');
DBMS_OUTPUT.put_line('BEGIN');
DBMS_OUTPUT.put_line(' DBMS_NETWORK_ACL_ADMIN.create_acl (');
DBMS_OUTPUT.put_line(' acl => ''' || i.acl || ''',');
DBMS_OUTPUT.put_line(' description => ''' || i.acl || ''',');
DBMS_OUTPUT.put_line(' principal => ''' || i.principal || ''',');
DBMS_OUTPUT.put_line(' is_grant => ' || i.is_grant || ',');
DBMS_OUTPUT.put_line(' privilege => ''' || i.privilege || ''',');
DBMS_OUTPUT.put_line(' start_date => ' || get_timestamp(i.start_date) || ',');
DBMS_OUTPUT.put_line(' end_date => ' || get_timestamp(i.end_date) || ');');
DBMS_OUTPUT.put_line(' COMMIT;');
DBMS_OUTPUT.put_line('END;');
DBMS_OUTPUT.put_line('/');
DBMS_OUTPUT.put_line(' ');
l_last_acl := i.acl;
l_last_principal := i.principal;
l_last_privilege := i.privilege;
END IF;
IF l_last_principal <> i.principal
OR (l_last_principal = i.principal AND l_last_privilege <> i.privilege) THEN
-- Add another principal to an existing ACL.
DBMS_OUTPUT.put_line('BEGIN');
DBMS_OUTPUT.put_line(' DBMS_NETWORK_ACL_ADMIN.add_privilege (');
DBMS_OUTPUT.put_line(' acl => ''' || i.acl || ''',');
DBMS_OUTPUT.put_line(' principal => ''' || i.principal || ''',');
DBMS_OUTPUT.put_line(' is_grant => ' || i.is_grant || ',');
DBMS_OUTPUT.put_line(' privilege => ''' || i.privilege || ''',');
DBMS_OUTPUT.put_line(' start_date => ' || get_timestamp(i.start_date) || ',');
DBMS_OUTPUT.put_line(' end_date => ' || get_timestamp(i.end_date) || ');');
DBMS_OUTPUT.put_line(' COMMIT;');
DBMS_OUTPUT.put_line('END;');
DBMS_OUTPUT.put_line('/');
DBMS_OUTPUT.put_line(' ');
l_last_principal := i.principal;
l_last_privilege := i.privilege;
END IF;
IF l_last_host <> i.host||':'||i.lower_port||':'||i.upper_port THEN
DBMS_OUTPUT.put_line('BEGIN');
DBMS_OUTPUT.put_line(' DBMS_NETWORK_ACL_ADMIN.assign_acl (');
DBMS_OUTPUT.put_line(' acl => ''' || i.acl || ''',');
DBMS_OUTPUT.put_line(' host => ''' || i.host || ''',');
DBMS_OUTPUT.put_line(' lower_port => ' || NVL(TO_CHAR(i.lower_port),'NULL') || ',');
DBMS_OUTPUT.put_line(' upper_port => ' || NVL(TO_CHAR(i.upper_port),'NULL') || ');');
DBMS_OUTPUT.put_line(' COMMIT;');
DBMS_OUTPUT.put_line('END;');
DBMS_OUTPUT.put_line('/');
DBMS_OUTPUT.put_line(' ');
l_last_host := i.host||':'||i.lower_port||':'||i.upper_port;
END IF;
END LOOP;
END;
/
-- /sys/acls/apex21_MISO_open_acl_file.xml
BEGIN
DBMS_NETWORK_ACL_ADMIN.drop_acl (
acl => '/sys/acls/apex21_MISO_open_acl_file.xml');
COMMIT;
END;
/
BEGIN
DBMS_NETWORK_ACL_ADMIN.create_acl (
acl => '/sys/acls/apex21_MISO_open_acl_file.xml',
description => '/sys/acls/apex21_MISO_open_acl_file.xml',
principal => 'APEX_210100',
is_grant => true,
privilege => 'connect',
start_date => TO_TIMESTAMP_TZ('10-FEB-2022 19:17:27.087684000
+00:00','DD-MON-YYYY HH24:MI:SS.FF TZH:TZM'),
end_date => NULL);
COMMIT;
END;
/
BEGIN
DBMS_NETWORK_ACL_ADMIN.assign_acl (
acl => '/sys/acls/apex21_MISO_open_acl_file.xml',
host => '*',
lower_port => 1,
upper_port => 9999);
COMMIT;
END;
/
-- NETWORK_ACL_D2DB0EE691B34C2DE053B310000A0394
BEGIN
DBMS_NETWORK_ACL_ADMIN.drop_acl (
acl => 'NETWORK_ACL_D2DB0EE691B34C2DE053B310000A0394');
COMMIT;
END;
/
BEGIN
DBMS_NETWORK_ACL_ADMIN.create_acl (
acl => 'NETWORK_ACL_D2DB0EE691B34C2DE053B310000A0394',
description => 'NETWORK_ACL_D2DB0EE691B34C2DE053B310000A0394',
principal => 'ADMIN',
is_grant => true,
privilege => 'smtp',
start_date => NULL,
end_date => NULL);
COMMIT;
END;
/
BEGIN
DBMS_NETWORK_ACL_ADMIN.assign_acl (
acl => 'NETWORK_ACL_D2DB0EE691B34C2DE053B310000A0394',
host => '*',
lower_port => NULL,
upper_port => NULL);
COMMIT;
END;
/
BEGIN
DBMS_NETWORK_ACL_ADMIN.add_privilege (
acl => 'NETWORK_ACL_D2DB0EE691B34C2DE053B310000A0394',
principal => 'MISO',
is_grant => true,
privilege => 'smtp',
start_date => NULL,
end_date => NULL);
COMMIT;
END;
/
BEGIN
DBMS_NETWORK_ACL_ADMIN.add_privilege (
acl => 'NETWORK_ACL_D2DB0EE691B34C2DE053B310000A0394',
principal => 'APEX_210100',
is_grant => true,
privilege => 'smtp',
start_date => NULL,
end_date => NULL);
COMMIT;
END;
/
BEGIN
DBMS_NETWORK_ACL_ADMIN.add_privilege (
acl => 'NETWORK_ACL_D2DB0EE691B34C2DE053B310000A0394',
principal => 'MISO',
is_grant => true,
privilege => 'smtp',
start_date => NULL,
end_date => NULL);
COMMIT;
END;
/
BEGIN
DBMS_NETWORK_ACL_ADMIN.assign_acl (
acl => 'NETWORK_ACL_D2DB0EE691B34C2DE053B310000A0394',
host => 'smtp.email.us-phoenix-1.oci.oraclecloud.com',
lower_port => 587,
upper_port => 587);
COMMIT;
END;
/
BEGIN
DBMS_NETWORK_ACL_ADMIN.add_privilege (
acl => 'NETWORK_ACL_D2DB0EE691B34C2DE053B310000A0394',
principal => 'APEX_210100',
is_grant => true,
privilege => 'smtp',
start_date => NULL,
end_date => NULL);
COMMIT;
END;
/
BEGIN
DBMS_NETWORK_ACL_ADMIN.add_privilege (
acl => 'NETWORK_ACL_D2DB0EE691B34C2DE053B310000A0394',
principal => 'ADMIN',
is_grant => true,
privilege => 'smtp',
start_date => NULL,
end_date => NULL);
COMMIT;
END;
/
When I try to grant execute on
grant execute on apex_210100.WWV_FLOW_WEBSERVICES_API to miso;
ORA-01031: insufficient privileges
grant execute on apex_210100.WWV_FLOW_COLLECTION to miso;
ORA-01031: insufficient privileges
grant dba to miso;
ORA-01924: role 'DBA' not granted or does not exist
grant execute any procedure to miso;
work? why?
I need help , support team ticket goes unanswered.