Re: Security under listener

From: Christopher M. Day <christopher.day_at_rdbms.freeserve.co.uk>
Date: Wed, 27 Jan 1999 21:20:51 +0000
Message-ID: <36AF8333.E733694A@rdbms.freeserve.co.uk>

Alexandre,

Alter your PROTOCOL.ORA file on the server and add the following lines

tcp.validnode_checking = yes

tcp.excluded_nodes = (www.experian.co.uk,

                                   10.1.45.2
                                   192.33.14.1)

This will exclude the forbidden IP address and include everyone else. (To permit certain clients but exclude everyone else use tcp.invited_nodes)

Chris.

Alexandre Mavel wrote:
>
> S_at_lut,
>
> Does anybody know :
> How to forbid certain clients (certain IP adress) to connect to Oracle via
> sqlplus
> I think it is a security parameter in the listener but cannot find what ?
>
> PS: I dont want to forbid acces at an OS stage.
>
> Thanks in advance.
>
> Alexandre Mavel
> amavel_at_partner.auchan.com
Received on Wed Jan 27 1999 - 15:20:51 CST