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
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;
/

Related Topics
DBMS_NETWORK_ACL_ADMIN
Packages
UTL_HTTP
UTL_INADDR
UTL_MAIL
UTL_SMTP
UTL_TCP
What's New In 12cR1
What's New In 12cR2

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2017 Daniel A. Morgan All Rights Reserved