Re: Allow connections through certain listener only for one user

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
> --
> http://www.freelists.org/webpage/oracle-l

--
http://www.freelists.org/webpage/oracle-l




--
http://www.freelists.org/webpage/oracle-l

Other related posts: