Subject RE: [firebird-support] IP or Machine name from trigger
Author Ross Ryding
Does anyone know a method to do this within the 1.5 framework?



_____

From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Steve Wiser
Sent: Monday, July 09, 2007 7:49 AM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] IP or Machine name from trigger



oh yeah (duh), i guess i need some more coffee

Ross Ryding wrote:
>
> I would if I knew from within the server how to determine the client
> address. I guess I can move to 2.01 and use the new routine they added.
>
> _____
>
> From: firebird-support@ <mailto:firebird-support%40yahoogroups.com>
yahoogroups.com
> <mailto:firebird-support%40yahoogroups.com>
> [mailto:firebird-support@ <mailto:firebird-support%40yahoogroups.com>
yahoogroups.com
> <mailto:firebird-support%40yahoogroups.com>] On Behalf Of Steve Wiser
> Sent: Friday, July 06, 2007 2:44 PM
> To: firebird-support@ <mailto:firebird-support%40yahoogroups.com>
yahoogroups.com
> <mailto:firebird-support%40yahoogroups.com>
> Subject: Re: [firebird-support] IP or Machine name from trigger
>
> maybe use a udf?
>
> Ross Ryding wrote:
> >
> > Is it possible to determine IP number or Machine name of client that is
> > making the request? Our application (MRP SYSTEM) has everyone making
> > request as default username and password which is stupid but it just
> > is. I want to be able to determine who is making a change to the
> > database from a trigger, I know how to get the time and understand what
> > fields are being changed but can not determine anyway to tie that to a
> > machine or person.
> >
> > thanks ross
> >
> >
>
> [Non-text portions of this message have been removed]
>
>





[Non-text portions of this message have been removed]