Subject RE: [firebird-support] FB number of connections with Usernames.count
Author Alan McDonald
> 08.03.2010 10:18, Tony Christiansen wrote:
> >
> > It appears that in FB2.0 it would return the correct number of
> > connections regardless of what login was used but with FB2.1.3 it
> > returns 1 unless I am connected as SYSDBA.
> >
> > Could someone confirm this change of behaviour (I could see nothing
> in
> > the notes)
>
> Yes, in FB 2.1 user can see only its own attachments no matter via
> API or monitoring tables.
>
> --
> SY, SD.

unless you modify security2.fdb to grant select to public on the users view.
Alan