> Hi
>
> I would like to make changes to security2.fdb in firebird version 2.1.
> I would like to enable users to see what other users are connected to
> the a DB.
>
> In december I asked this:
>
> --- snip ---
> > I have properbly not read this in the release notes, but is it true,
> > that when retriving connected users I can only see all, if I connect
> as
> > SYSDBA?
> >
> > Connecting as someuser only shows someuser as connected?
> >
> > Michae
> >
>
> true - unless you modify security2.fdb to grant select on the users
> view to
> public
>
>
> --- snip ---
>
> My question is now. Is there any way I can modify / change the
> security2 DB without actually being at the machine in question?
> I would like to do the above, but I would like very much to do that
> with an update of our program.
>
> Regards
> Micahel
>

with fb 2.1.x you do not have direct access the the security2.fdb file. It
is impossible to modify it unless you take it offline, modify it and place
it back again. For that - you need to be at the console or at least a remote
console.
Alan