Oracle 12cR2 DBMS_NETWORK_ACL

Oracle DBMS_NETWORK_ACL_UTILITY Version 12.2.0.1

General Information

Library Note

Morgan's Library Page Header

"I spent my entire adult life looking out for the well-being, the training, the equipping of the troops for whom I was responsible. I will not be lectured about what our military needs by a five-deferment draft dodger,"

~ Sen. Tammy Duckworth

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

First Available 11.1.0.6

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; 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 dbms_network_acl_utility.domains('192.168.1.119')

      FROM dual;

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;

SELECT dbms_network_acl_utility.domain_level('192.168.1.119')

      FROM dual;

EQUALS_HOST

Undocumented dbms_network_acl_utility.equals_host( host1 IN VARCHAR2, host2 IN VARCHAR2) RETURN NUMBER; 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;

      /