Getting connected users information

Hello everyone

I've searched but I still haven't found out where I can get information about a connected user in Firebird...
I wanna know things like.. username, connectionid, host, time... this stuff.
Is there any kind of table that keeps this information?

Thank you.

Well, I have to disappoint you:

You cannot.

This functionality is expected for Fb 2.0

Oh Lord. That is NOT good.

Anyways, thanks you very much for answering.

Well, there is _some_ info about connected users available, but it only works on a per database basis and is only accessible via the API, I believe. So it's pretty much useless in itself (except if you want to check if there's no-one else besides yourself that's connected)

Actually I was trying to do a trigger.. I use it in Oracle and now I`m trying to adapt it to FB. When a user deletes from a specific table, my trigger will record a lot of stuff.. including host name. So all this mess is to find the host name of a connected user.

Well, you can get the user via CURRENT_USER, but for hostname etc, there's no such thing yet. A connectionID (a numerical value) is available in Firebird 1.5: check the release notes for this.

Thank you