Re: Securing Oracle server from internal acces

From: DA Morgan <damorgan_at_psoug.org>
Date: Sun, 04 Feb 2007 14:01:03 -0800
Message-ID: <1170626463.273186@bubbleator.drizzle.com>

Ramon F Herrera wrote:

> On Feb 4, 12:29 pm, "Ramon F Herrera" <r..._at_conexus.net> wrote:

>> Is there any way I can restrict the clients to my Oracle server, by IP
>> address (or by DNS name, of course)? Let's say that the only allowed
>> client connections have to come from the same host where the server is
>> running.
>>
>> TIA
>>
>> -Ramon

> 
> Sorry. I always use the latest & greatest: 10gR2.
> 
> -Ramon

With valid node checking it doesn't much matter. It has been in Oracle for many versions.

You can also use the SYS_CONTEXT function to validate much of this information and then ALTER SYSTEM KILL SESSION as you wish.

You will find demos of all of these in Morgan's Library at www.psoug.org.

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

Received on Sun Feb 04 2007 - 16:01:03 CST