Daniel Morgan <damorgan_at_exesolutions.com> wrote in message news:<3CFC41D5.BAD95902_at_exesolutions.com>...
> 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
Thank you. Im not too familiar with event level database triggers. Ill
check them out.
Received on Tue Jun 04 2002 - 05:30:01 CDT
