| 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 |
user_network_acl_privileges |
|
| Security Model |
Execute is granted to PUBLIC |
| |
CONTAINS_HOST (new 11.2.0.1)  |
| 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;
/ |
| |
| 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; |
| |
EQUALS_HOST (new 11.2.0.1)  |
| 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;
/ |