Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Security Question : Restricting SQL*Net connectivity

Re: Security Question : Restricting SQL*Net connectivity

From: Telemachus <telemachus_at_ulysseswillreturn.net>
Date: Fri, 28 Mar 2003 11:55:02 -0000
Message-ID: <qKWga.5488$pK2.5509@news.indigo.ie>


But lets not forget that anyone can give themselves an IP address so if that's all the level of security that you want , fine otherwise you might want to check out the SQL*Net security architecture in more detail. "Mario" <mario_jvn_NONSPAM_at_yahoo.it> wrote in message news:4q388v03mqcnfo7003sh6si0kqkpjtn4lm_at_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:
>
>

http://download-west.oracle.com/docs/cd/A87860_01/doc/network.817/a76933/par ams.htm#478104
>
> careful with that ... wrapped link, Chenwenjian.
>
> Mario from Rome, Europe
Received on Fri Mar 28 2003 - 05:55:02 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US