OKTA ACL script (sample)
BEGIN
DBMS_NETWORK_ACL_ADMIN.CREATE_ACL(
acl => 'open_id.xml',
description => 'OPEN ID ACL functionality',
principal => 'APEX_200100',
is_grant => TRUE,
privilege => 'connect');
END;
/
BEGIN
DBMS_NETWORK_ACL_ADMIN.APPEND_HOST_ACL (
host => 'sandbox.intergraphsmartcloud.com',
acl => 'open_id.xml');
END;
/
MS Azure ACL Script (sample)
BEGIN
DBMS_NETWORK_ACL_ADMIN.CREATE_ACL(
acl => 'open_id.xml',
description => 'OPEN ID ACL functionality',
principal => 'APEX_200100',
is_grant => TRUE,
privilege => 'connect');
END;
/
begin
DBMS_NETWORK_ACL_ADMIN.APPEND_HOST_ACL (
host => 'Login.microsoftonline.com',
acl => 'open_id.xml');
end;
/
begin
DBMS_NETWORK_ACL_ADMIN.APPEND_HOST_ACL (
host => 'Graph.microsoft.com',
acl => 'open_id.xml');
end;
/
begin
DBMS_NETWORK_ACL_ADMIN.SET_HOST_ACL (
host => '*.office.com',
acl => 'open_id.xml');
end;
/