Logon trigger

I am writing a logon trigger to implement some Sarbanes Oxley regulations.
Users may be connecting using listener:

sqlplus scott/password_at_svcname

or bypassing listener:

sqlplus scott/password

Is there a way to distinguish the two in logon trigger. I know in logon trigger one can get IP address, OS user etc, but how does one distinguish between the two
cases.

Thanks a lot,

Prem Received on Tue Nov 23 2004 - 09:11:17 CST