ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling
complimentary technical Workshops on Database Security for the first 30
Oracle Database customers located anywhere in North America, EMEA, LATAM, or
APAC that send an email to
asra_us@oracle.com. Request a Workshop for
your organization today.
Purpose
Provides PL/SQL procedures to support internet addressing. It provides an API to retrieve host names and IP addresses of local and remote hosts.
AUTHID
CURRENT_USER
Dependencies
DBMS_ISCHED
DBMS_ISCHED_REMOTE_ACCESS
UTL_INA_LIB
Documented
Yes
Exceptions
Error Code
Reason
ORA-24247
network_access_denied: Network privileges issue
ORA-29257
unknown_host: Host not found
First Available
8.1.7
Security Model
Owned by SYS with EXECUTE granted to PUBLIC, DVSYS, and ORACLE_OCM
SELECT sid, machine, utl_inaddr.get_host_address(SUBSTR(machine, INSTR(machine,'\')+1)) ip
FROM gv$session
WHERE type = 'USER'
AND username IS NOT NULL;