Oracle | DBMS_NETWORK_ACL

Oracle DBMS_NETWORK_ACL_UTILITY Version 21c

General Information

Library Note

Morgan's Library Page Header

Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.

Purpose Provides utility functions that facilitate managing network access permissions.

AUTHID DEFINER

Data Types TYPE domain_table IS TABLE OF VARCHAR2(1000);

Dependencies

DBMS_NETWORK_ACL_ADMIN

Documented Yes: Packages and Types Reference

Exceptions

Error Code	Reason
ORA-24247	Access Denied

First Available 11.1

Security Model Owned by SYS with EXECUTE granted to PUBLIC

Source {$ORACLE_HOME}/rdbms/admin/dbmsnacl.sql

Subprograms

CONTAINS_HOST	DOMAIN_LEVEL	EQUALS_HOST
DOMAINS

CONTAINS_HOST

Undocumented dbms_network_acl_utility.contains_host( host IN VARCHAR2, domain IN VARCHAR2) RETURN NUMBER DETERMINISTIC; pragma interface(C, contains_host);

set serveroutput on

      

      DECLARE

       x NUMBER;

      BEGIN

        x := dbms_network_acl_utility.contains_host('192.168.1.119', 'mlib.org');

        dbms_output.put_line(x);

      END;

      /

DOMAINS

For a given host, return the domains whose ACL assigned will be used to determine if a user has the privilege to access the given host or not. When the IP address of the host is given, return the subnets instead. dbms_network_acl_utility.domains(host IN VARCHAR2) RETURN domain_table PIPELINED;

SELECT * FROM TABLE(dbms_network_acl_utility.domains('192.168.1.119'));

      

      COLUMN_VALUE

      -----------------------------------------------------------------------

      192.168.1.119

      192.168.1.*

      192.168.*

      192.*

      *

DOMAIN_LEVEL

Return the domain level of the given host name, domain, or subnet dbms_network_acl_utility.domain_level(host IN VARCHAR2) RETURN NUMBER DETERMINISTIC;

SELECT dbms_network_acl_utility.domain_level('192.168.1.119')

      FROM dual;

      

      DBMS_NETWORK_ACL_UTILITY.DOMAIN_LEVEL('192.168.1.119')

      ------------------------------------------------------

                                                     
      4

EQUALS_HOST

Undocumented dbms_network_acl_utility.equals_host( host1 IN VARCHAR2, host2 IN VARCHAR2) RETURN NUMBER DETERMINISTIC; pragma interface(C, equals_host);

set serveroutput on

      

      DECLARE

        x NUMBER;

      BEGIN

        x := dbms_network_acl_utility.contains_host('192.168.1.119', '192.168.1.120');

        dbms_output.put_line(x);

      END;

      /

      32