Re: Security Question : Restricting SQL*Net connectivity

From: Mario <mario_jvn_NONSPAM_at_yahoo.it>
Date: Fri, 28 Mar 2003 10:37:08 +0100
Message-ID: <4q388v03mqcnfo7003sh6si0kqkpjtn4lm@4ax.com>

On 27 Mar 2003 23:39:14 -0800, chenwenjian_at_yahoo.com (chenwenjian) wrote:

>If I need to limit SQL*Net connectivity to the Oracle Database Server
>from only one particular workstation, how can I achieve this ?

Hi Chenwenjian,

you have to put the following lines in the SQLNET.ORA file

Syntax:

protocol.validnode_checking = YES
protocol.invited_nodes = (hostname | ip_address, hostname | ip_address,...)

where 'protocol' is the protocol used by your workstation to connect with Oracle (most likely TCP); for example:

tcp.validnode_checking = YES
tcp.invited_nodes = (10.1.1.2, trusted_machine)

For more details see:

careful with that ... wrapped link, Chenwenjian.

Mario from Rome, Europe Received on Fri Mar 28 2003 - 03:37:08 CST