|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
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. |
|
#2
|
|||
|
|||
|
Well, I have to disappoint you:
You cannot. This functionality is expected for Fb 2.0
__________________
Martijn Tonies Database Workbench: developer IDE for Firebird, MySQL, InterBase, MSSQL Server and Oracle Upscene Productions http://www.upscene.com |
|
#3
|
|||
|
|||
|
Quote:
Oh Lord. That is NOT good. Anyways, thanks you very much for answering. |
|
#4
|
|||
|
|||
|
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)
|
|
#5
|
|||
|
|||
|
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.
|
|
#6
|
|||
|
|||
|
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.
|
|
#7
|
|||
|
|||
|
Thank you
![]() |
![]() |
| Viewing: Dev Shed Forums > Databases > Firebird SQL Development > Getting connected users information |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|