Re: Allow connections through certain listener only for one user
- From: jo_holvoet@xxxxxxxx
- To: cichomitiko@xxxxxxxxx
- Date: Thu, 13 Oct 2005 12:12:09 +0200
Be aware that the file is only checked at listener start; it will translate
hostnames to ip addresses so the client machine needs a fixed ip address.
mvg/regards
Jo
"Radoulov,
Dimitre" To: <gorbyx@xxxxxxxxx>,
"Oracle-L" <oracle-l@xxxxxxxxxxxxx>
<cichomitiko@gmail cc:
.com> Subject: Re: Allow connections
through certain listener only for one user
Sent by:
oracle-l-bounce@fr
eelists.org
10/13/2005 12:04
Please respond to
cichomitiko
Do the specific users use the same client host?
If not, you can use invited/excluded nodes configuration in
protocol.ora/sqlnet.ora file.
TCP.VALIDNODE_CHECKING = YES
TCP.INVITED_NODES = (host1, host2)
TCP.VALIDNODE_CHECKING = YES
TCP.EXCLUDED_NODES = (host1, host2)
HTH,
Dimitre Radoulov
----- Original Message -----
From: "Alex Gorbachev" <gorbyx@xxxxxxxxx>
To: "Oracle-L" <oracle-l@xxxxxxxxxxxxx>
Sent: Wednesday, October 12, 2005 9:47 PM
Subject: Allow connections through certain listener only for one user
> Hi all,
>
> We have several listeners configured for one instance. We need to
> limit connections through specific listener to a specific user only.
>
> Initial idea was to define a unique service name for each listener and
> write simple after logon trigger. However, I cannot figure out how to
> get in 9i service name that session is connected to. Any ideas?
>
> Are there other solutions to that?
>
> Thanks,
> Alex
> --
> //www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts: