Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Logon trigger
premmehrotra_at_hotmail.com (Prem K Mehrotra) wrote in
news:43441e77.0411230711.1ecaec64_at_posting.google.com:
> 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
From V$SESSION the MACHINE column holds the answer. When MACHINE is the same as the name of the DB server, then that session is "local"; otherwise it is a "remote" connection.
QED! HTH & YMMV HAND Received on Tue Nov 23 2004 - 19:44:22 CST