Working with Oracle Database Network ACL

What is Network ACL?

Oracle Network ACL(Access Control List) controls the network access for database users and roles.

Query to check for the available ACL in the database

COL ACL_OWNER FOR A12

COL ACL FOR A67

COL HOST FOR A34

col PRINCIPAL for a20

col PRIVILEGE for a13

select ACL_OWNER,ACL,HOST,LOWER_PORT,UPPER_PORT FROM dba_network_acls;

select ACL_OWNER,ACL,PRINCIPAL,PRIVILEGE from dba_network_acl_privileges;

Creation of ACL: 

BEGIN

DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL (

  acl => '/sys/acls/db_permissions.xml',

  host => 'mail.hostname.com',

  lower_port => 25,

  upper_port => 25);

END;

/

Assign ACL Permission to Specific users:

exec DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE('DB_permissions.xml', '<username>', TRUE, 'connect');

exec DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE('DB_permissions.xml', '<username>', TRUE, 'resolve');