Subject Privileges on monitoring tables
Author Stefan Sinne
Hello,

When connecting to a Firebird 2.5.4 database, a non-SYSDBA user can make
a select on MON$ATTACHMENTS without any problem.

Then SYSDBA grants and revokes some privilege, like

grant all on mon$attachments to procedure xyz;
commit;
revoke all on mon$attachments from procedure xyz;
commit;

And after this the non-SYSDBA user gets a permission error when
selecting from MON$ATTACHMENTS:
no permission for read/select access to TABLE MON$ATTACHMENTS

Is this by design, or is something wrong with my installation?

Thanks,

Stefan