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

Ryan wrote:

> 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
> >

I mean the logon trigger in the database ... this has nothing to do with Forms or any other external application or interface.

The group you chose to post in is c.d.o.server ... not c.d.o.tools. The solution provided is consistent with where you placed your message. But it is just as applicable in Forms.

Daniel Morgan Received on Mon Jun 03 2002 - 23:28:05 CDT