$page_title = $titlebar_text; $header_bar_text = $titlebar_text; ///////////////////////////////////// // get header include('rlib_header.php'); // print << Oracle DBMS_NETWORK_ACL_UTILITY Version 11.1  
General Information
Purpose Provides the utility functions to facilitate the network access permissions
Source {$ORACLE_HOME}/rdbms/admin/dbmsnacl.sql
First Available 11.1
Defined Data Type TYPE domain_table IS TABLE OF VARCHAR2(1000);
Dependencies dbms_network_acl_admin
 
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;
 
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;
 
Related Topics
DBMS_NETWORK_ACL_ADMIN
UTL_HTTP
UTL_INADDR
UTL_MAIL
UTL_SMTP
UTL_TCP
  EOM; ///////////////////////////////////// // get footer include('rlib_footer.php'); ?>