Subject Re: changes to isc_info_user_names in FB 2.1 breaks my application.
Author Adam
--- In firebird-support@yahoogroups.com, Trond <trond@...> wrote:
>
> In my application a user can pull up a window and see who else of his
> colleague is logged in at the moment, and communicate with him/her
via a
> chat function in the application. This list of logged in users is
returned
> by isc_info_user_names. The new restriction in 2.1 that returns only
your
> own name unless you are SYSDBA or OWNER breaks this function. Any
chance
> of getting the old behavior back ?

I don't think that is going to happen. On the other hand, it would be
a reasonably trivial task to write your own table to hold such
information and populate it from your application. Perhaps you could
even use the Connect / Disconnect triggers to maintain the table?

Adam