Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Access Control List (ACL) in APEX

Ankan ChandaAug 23 2021 — edited Aug 23 2021

Hi team,
How to use access control list in APEX as I need to pass on certain hosts inside ACL to use Oracle Autonomous database? I have also observed that to create an access control we need to pass the acl as an xml file, for eg. ,
BEGIN
DBMS_NETWORK_ACL_ADMIN.create_acl (
acl => 'local_sx_acl_file.xml',
description => 'A test of the ACL functionality',
principal => 'WC',
is_grant => TRUE,
privilege => 'connect',
start_date => SYSTIMESTAMP,
end_date => NULL);
end;

begin
DBMS_NETWORK_ACL_ADMIN.assign_acl (
acl => 'local_sx_acl_file.xml',
host => 'localhost',
lower_port => 9002,
upper_port => NULL);
end;
How to create the xml for ACL in APEX? How can we get access of the Access Control List inside APEX?
Can we get the "Update Network Access" provision in the Always free services of Oracle ADW?
Thanks and Regards
Ankan

Comments
Post Details
Added on Aug 23 2021
1 comment
4,174 views