What is Network Access Control List and How To Use It

 

From 11gR1, access to external network services in Oracle databases is done through the Access Control List (ACL). It is possible to perform operations with the package named DBMS_NETWORK_ACL_ADMIN.

In order to use the following PL / SQL packages, network ACL must be created and authorized. Otherwise, “ORA-24247: network access denied access control list (ACL)” error will occur.

• UTL_TCP
• UTL_HTTP
• UTL_SMTP
• UTL_MAIL

 

With the following procedure, we create a “network acl” called “network_services.xml” for SCOTT user.

We give connect and resolve privileges to the corresponding user. Thus, the SCOTT user will be able to receive service from all hosts.

With DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE, other users can also be authorized for this “network acl”.

DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL can authorize other hosts.

It is also possible to authorize individual hosts instead of authorizing for all hosts.

 

You can use the following query to query whether the host is authorized:

 

For defined ACL and information:

dbtut
Author: dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

Your email address will not be published. Required fields are marked *