From: Hamacker <ham...@vi...> - 2002-12-13 16:11:48
|
sugestion : not allow user (sysdba too) to update system tables. Porpose : Deny mal-intencional programs and protect data for future restore. The number of gui to administrate firebirdsql is groing up too fast. but somes application modify some aspects in tables, views, sp's directly on system tables (rdb$...) without sql sintaxe. And some times its run and its functionly for user developer. But on production...when its need to repair a table or restore, bgak and other official programs fails. One example for this problem : there are some programs that modify constraint directy on rdb$source without a convencional "alter table" and previous data are not validated and future restore will be fail. One simple change column "null" to "not null" with these applications will be suficient to fail future restore. To allow user table modify system tables would be created one more parameter in firebird.conf or other configuration file. In official firebirdsql homepage could be exist one list of "official gui for firebird managers" that respect sql sintaxes and dont modify system tables directly. Thanks a lot, Hamacker |