On 2021-08-03 10:28, Gabor Boros wrote:
Nice idea but this feature useless in current form.
The documentation say:
"Table RDB$CONFIG is populated from in-memory structures upon request
and its instance is preserved for the SQL query lifetime. For security
reasons, access to this table is allowed for administrators only.
Non-privileged users see no rows in this table (and no error is
raised)."
In practice who have admin rights knows the configuration.
Very good if can create an on connect trigger which restrict the
connection to SuperServer only with a defined minimal memory
configuration. But cannot because the normal users not see any records
from RDB$CONFIG and use of GRANT not help.
I don't really agree with you that admins will always no all details of
configuration for each and every database. Not to mention that some
database admins may not be aware of any config at all, they are just
concerned with the database itself.
That said, I guess this feature needs a system privilege. Consider
creating an improvement ticket.
Mark
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
