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

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 - 16:07:27 CDT