#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2003
    Location
    Goi‚nia,GO,Brazil
    Posts
    17
    Rep Power
    0

    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. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2003
    Posts
    250
    Rep Power
    15
    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
  4. #3
  5. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2003
    Location
    Goi‚nia,GO,Brazil
    Posts
    17
    Rep Power
    0
    Originally posted by upscene
    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.
  6. #4
  7. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2003
    Posts
    250
    Rep Power
    15
    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)
    Martijn Tonies
    Database Workbench: developer IDE for Firebird, MySQL, InterBase, MSSQL Server and Oracle
    Upscene Productions
    http://www.upscene.com
  8. #5
  9. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2003
    Location
    Goi‚nia,GO,Brazil
    Posts
    17
    Rep Power
    0
    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.
  10. #6
  11. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2003
    Posts
    250
    Rep Power
    15
    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.
    Martijn Tonies
    Database Workbench: developer IDE for Firebird, MySQL, InterBase, MSSQL Server and Oracle
    Upscene Productions
    http://www.upscene.com
  12. #7
  13. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2003
    Location
    Goi‚nia,GO,Brazil
    Posts
    17
    Rep Power
    0
    Thank you

IMN logo majestic logo threadwatch logo seochat tools logo