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