Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Logon trigger

Re: Logon trigger

From: Pete's <empete2000_at_yahoo.com>
Date: 23 Nov 2004 15:05:50 -0800
Message-ID: <6724a51f.0411231505.3d753c00@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

To "bypass the listener", wouldn't they be logged into the server, thus being a local connection?

HTH,
Pete's Received on Tue Nov 23 2004 - 17:05:50 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US