Re: Allow connections through certain listener only for one user

That wouldn't work - no Oracle username here.
We will probably go for after logon trigegger and filter so that
connection from certain IP addresses can be made as only one certain
Oracle user.
Thanks,
Alex

2005/10/13, Radoulov, Dimitre <cichomitiko@xxxxxxxxx>:
> 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
>
>


--
Best regards,
Alex Gorbachev
--
http://www.freelists.org/webpage/oracle-l

Other related posts: