CODE
Oracle Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
PSOUG Home Code Snippets Oracle Reference Oracle Functions PSOUG Forum Oracle Blogs Bookmark and Share
 
 Search the Reference Library pages:  

Free
Oracle Magazine
Subscriptions
and Oracle White Papers

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
 
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us [156 users online]    © 2010 psoug.org