Subject | Privileges on monitoring tables |
---|---|
Author | Stefan Sinne |
Post date | 2015-09-29T09:30:26Z |
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
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