Re: Getting the IP address of someone connecting through web forms

Thanks... However, I think you mean the forms level on-logon trigger right? I need to get this information for use in a menu option. The user will not necessarily access any form and if they do... there are alot to choose from.

Dont remember if there is an on-logon database trigger. Is that what you mean?

"Daniel Morgan" <dmorgan_at_exesolutions.com> wrote in message news:3CFBDA8A.DF304611_at_exesolutions.com...
> Ryan wrote:
>
> > The reason is that I have absolutely no say in the matter and that the
> > client wants it that way. I have been given requirements that I need to
> > meet. I dont always like them, but I cannot change them.
> >
> > BTW, SYS_CONTEXT doesnt work... if I run it from the database I just get
the
> > server IP. This is a web application so the rules are different.
> >
> > "Daniel Morgan" <dmorgan_at_exesolutions.com> wrote in message
> > news:3CFBCB00.343643B1_at_exesolutions.com...
> > > Ryan Gaffuri wrote:
> > >
> > > > I know I can use
> > > >
> > > > Select SYS_CONTEXT('USERENV',('IP_ADDRESS')
> > > > from dual
> > > >
> > > > if I have 1 user per login. However, our users have a small number
of
> > > > login/passwords and they are shared. I have no control over this. If
a
> > > > specific user performs an action how do I get his specific IP
address?
> > > >
> > > > Not sure if the above method will work. Ive been playing with it. Or
> > > > am I wrong here. I think I can use a javabean, but I dont know Java
> > > > and I was told not to explore this option.
> > >
> > > A 'small number of login/passwords and they are shared'? Why? To what
> > > possible end other than to make security a joke? Why not just grant
CREATE
> > > SESSION and DBA to PUBLIC?
> > >
> > > Take a look at the options available for a on-logon trigger. You can
> > > capture all of that information at logon.
> > >
> > > Daniel Morgan
> > >
>
> I understand.
>
> Why didn't you look at what I suggested to you instead of just repeating
back to
> us what doesn't work?
>
> Daniel Morgan
>
Received on Mon Jun 03 2002 - 18:45:17 CDT