The reason is I don't want total user pass from a program
it will not be correct example improple shutdown or
etc the total user still will remains.

What one want is how many connections from client
connect to fire bird with from which pc name and ip address.

--- In firebird-support@yahoogroups.com, "Adam" <s3057043@...> wrote:
>
> > FireBird 1.5 Super Server version, Delphi 7.
> > I try to use Delphi "Interbase" components TIBDatabase.Usernames
> > but only can get user name.
> >
> > Because we need to know total users connected to server
> > and from which pc and ip address.
>
> You will need to insert this information into a table from your
> program when someone 'logs in'. There are reasonably simple windows
> calls for this information, and lots of sample Delphi functions.
>
> > Is it possible to e.g dll to write the function to get
> > local pc name and ip address and use user define function
> > to call this dll.
>
> Well you could write a UDF to get the PC Name and IP Address, but
this
> will be executed on the database server and so will contain
> information about the DATABASE SERVER. You don't want information
> about the server, you want information about the clients.
>
> > When everytime got user login a trigger
> > to write this information to a table or variable.
>
> There is no trigger on a connection, but there is also nothing
> stopping you from passing in this information from the login screen.
>
> Adam
>