With Oracle8i, a new SQL function was introduced: SYS_CONTEXT. This function
returns the value of an attribute associated with the context namespace.

A context namespace is a set of application-defined attributes that can be
set by a package by associating the namespace with itself.

Most of the default context-related/session-related values that can be obtained
through the use of SYS_CONTEXT, can also be obtained through the direct use of
USERENV (SELECT USERENV( ) FROM DUAL).


Oracle recommends that you use the application context feature or the
SYS_CONTEXT function with the USERENV option. These alternatives are
more secure and flexible. See the Oracle8i SQL Reference, Chapter 4
Functions: USERENV.


IP-ADDRESS:
-----------

To obtain the client IP-address of the currently connected, you use the
default context namespace:

SQL> SELECT SYS_CONTEXT('USERENV','IP_ADDRESS') "My IP Address" from dual;

My IP Address
---------------
141.143.51.105


NLS_LANG:
---------

To obtain the nls_lang:

SQL> SELECT SYS_CONTEXT('USERENV','LANGUAGE') "nls_lang" from dual;

nls_lang
----------------------------------------------------------------------
AMERICAN_AMERICA.WE8ISO8859P1


SQL> SELECT SYS_CONTEXT('USERENV','ISDBA') FROM dual;

isdba
--------------------------------------------------------------------------------
FALSE

=========================================================================================

HTHU

Ankur Shah
Oracle DBA
DHR-GA


----- Original Message -----
From: "Kate Monro" <[Email Address Removed] "LazyDBA.com Discussion" <[Email Address Removed] Wednesday, July 31, 2002 10:00 AM
Subject: security: restrict user by IP


| Does a standard install of Oracle 8.1.7 include a feature for restricting
| user access by IP?
|
| Thanks
| Kate
|

Oracle LazyDBA home page