Re: Logon trigger

empete2000_at_yahoo.com (Pete's) wrote in message news:<6724a51f.0411231505.3d753c00_at_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

What about using v$session.machine and v$instance.host_name.

HTH,
Pete's Received on Tue Nov 23 2004 - 22:19:28 CST