Search
  • Bheem

How to create Network Access Control List in oracle

When we try to connect external web API or other services from the oracle database or oracle APEX. we may have faced the error network access denied by access control list.


Run Below Code by login as sysdba

BEGIN
    dbms_network_acl_admin.append_host_ace(host => 'api.docparser.com', 
                                            lower_port => NULL, 
                                            upper_port => NULL, 
                                            ace => xs$ace_type(privilege_list => xs$name_list('connect', 'resolve'),principal_name => 'SNDTSTDB', principal_type => xs_acl.ptype_db)
                                           );
END;

principal_name --> your schema name

19 views0 comments

Recent Posts

See All

How to create network ACL in oracle database.

when you are calling third party API in oracle using UTL_HTTP then you will face Network access denied by ACL error if ACL is not created. To create ACLfirst login with sys account then run below code