Re: Allow connections through certain listener only for one user

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_at_gmail.com> To: "Oracle-L" <oracle-l_at_freelists.org> 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