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