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

  DBMS_NETWORK_ACL_ADMIN.append_host_ace (
    host       => '',
    lower_port => NULL ,
    upper_port => NULL ,
    ace        => xs$ace_type(privilege_list => xs$name_list('connect', 'resolve'),
                              principal_name => 'VEPRDDB',
                              principal_type => xs_acl.ptype_db));

--Host = Ip name or domain name

--Principal Name = database schema name

Thanks for reading

8 views0 comments

Recent Posts

See All

Check if you have any user that’s expired/lock

Error : The request could not be mapped to any database. Check the request URL is correct, and that URL to database mappings have been correctly configured SELECT username, account_status, created,