Re: Access based on IP Address and Username

rspai9_at_gmail.com wrote:
> We are trying to restrict access to the database depending on a
> combination of accessing machine's ip address and oracle username eg.
> user jack should be allowed to access only from the ip address
> 10.0.11.72 and not from any other ip address? Is this possible?
>
> Thanks in Advance for the Help.
>
> Regards,
> Raj

Go to Morgan's Library at www.psoug.org and look up the SYS_CONTEXT function. It can be used to identify the connecting IP address. If, however, connections are coming through an application server, it will be that address that is registered ... not the app server's client.

I do, however, like Mark Powell's original advice to you with respect to use valid node checking. You can find this in the library under invited_nodes. It is a valuable adjunct.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org