Re: UTL_INADDR package.

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Thu, 11 Mar 2004 23:40:40 -0800
Message-ID: <1079077211.653454@yasure>

Douglas Hawthorne wrote:

> "AMIT" <kumar_929_at_yahoo.co.uk> wrote in message
> news:6f94b59f.0403112202.4bbd7a59_at_posting.google.com...
> 

>>Hi,
>>
>>I like to ask about the UTL_INADDR package.
>>In order to use this package in my code should we prepare something
>>before using this package.
>> I mean should I grant some kind of privilege to the user or run some
>>utility?
>>
>>Any response will be good.
>>
>>Kumar
>>
>>
>>Sample
>>
>> utl_inaddr.get_host_name(sys_context('USERENV','IP_ADDRESS')));

> 
> 
> Kumar,
> 
> There appears to be no special privilege needed.  There are no special
> requirements mentioned in the "Oracle9i Supplied PL/SQL Packages and Types
> Reference, Release 2 (9.2)" manual for this package.  I tried a "SELECT
> utl_inaddr.get_host_name(sys_context('USERENV','IP_ADDRESS')) FROM dual"
> without encountering any problems under 9.2.0.1 for my test user.
> 
> Douglas Hawthorne

This package is built by $ORACLE_HOME/rdbms/admin/utlinad.sql which contains the following:

EXECUTE on this package is granted to PUBLIC.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)

Received on Fri Mar 12 2004 - 01:40:40 CST