From oracle-l-bounce@freelists.org Thu Oct 13 05:14:21 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j9DAELCR004531 for ; Thu, 13 Oct 2005 05:14:21 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j9DAEKvX004519 for ; Thu, 13 Oct 2005 05:14:20 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id C57B81FD476; Thu, 13 Oct 2005 05:14:13 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 10489-01; Thu, 13 Oct 2005 05:14:13 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id F0B021FD456; Thu, 13 Oct 2005 05:14:12 -0500 (EST) Date: Thu, 13 Oct 2005 12:12:09 +0200 From: jo_holvoet@amis.com Subject: Re: Allow connections through certain listener only for one user To: cichomitiko@gmail.com Cc: gorbyx@gmail.com, Oracle-L , oracle-l-bounce@freelists.org Message-id: MIME-version: 1.0 Content-Type: text/plain; charset=us-ascii X-MIMETrack: Serialize by Router on MailEU/AMI(Release 5.0.12 |February 13, 2003) at 13/10/2005 12:12:10 X-archive-position: 26896 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: jo_holvoet@amis.com Precedence: normal Reply-To: jo_holvoet@amis.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Level: X-Spam-Status: No, hits=-3.2 required=5.0 tests=AWL,BAYES_00,NO_REAL_NAME autolearn=no version=2.63 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: , "Oracle-L" 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" To: "Oracle-L" 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