SQL*NET V2.1 Restricting Access
From: Naren Chintala <naren_at_mink.att.com>
Date: 1996/02/07
Message-ID: <4fb3vo$4li_at_nntpa.cb.att.com>#1/1
Date: 1996/02/07
Message-ID: <4fb3vo$4li_at_nntpa.cb.att.com>#1/1
Hi..
I was wondering about the following:
Is it possible in SQL*NEt v2.1 to RESTRICT access to a database on node Z from users of a particular host (say node A) only and allow access to users from other hosts (nodes B,C,D).
Note: It is possible for users from node A to connect to the database on node Z using the connect description. I need to restrict the users from node A even though the have the connect description and username/ password.
Tried out the protocol.ora
(tcp.validate_node=yes,
tcp.excluded_hosts=(host1,host2...).
But it still allowed access to all the clients who had a valid tnsnames.ora connect descriptor!
Help...
naren
naren_at_mink.att.com
Received on Wed Feb 07 1996 - 00:00:00 CET