Forum Stats

  • 3,815,996 Users
  • 2,259,128 Discussions
  • 7,893,358 Comments

Discussions

Access Control List (ACL) in APEX

Ankan Chanda
Ankan Chanda Member Posts: 32 Green Ribbon
edited Aug 23, 2021 6:40AM in APEX Discussions

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

Tagged:

Answers