Re: Logon trigger

From: David Fitzjarrell <fitzjarrell_at_cox.net>
Date: 23 Nov 2004 15:19:57 -0800
Message-ID: <9711ade0.0411231519.574e38f@posting.google.com>

premmehrotra_at_hotmail.com (Prem K Mehrotra) wrote in message 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

You might try this:

sys_context('USER','TERMINAL')

I know on my Sun box I get this for local connections:

SQL> l
  1 select sys_context('USER','TERMINAL')   2* from dual
SQL> / SYS_CONTEXT('USER','TERMINAL')

---

pts/3

SQL> And for remote connections I get this:

SQL> select sys_context('USER','TERMINAL')   2 from dual;

SYS_CONTEXT('USER','TERMINAL')

---

DFMQ5T21 SQL> Both are connected to the same instance, one locally, one through my XP Pro box.

This might be a usable solution.

David Fizjarrell Received on Tue Nov 23 2004 - 17:19:57 CST