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