On the flags front.


The field rdb$flags in rdb$relations has only one setting
defined, REL_sql which indicates whether the relation was
defined with SQL and thus has SQL-type security (access
denied unless permitted) or with GDML and has the old style
security (access permitted unless denied). So there's
actually plenty of room in it to hold additional values
like:

REL_permanent 2
REL_view 4
REL_external 8
REL_temporary 16
REL_preserve_on_commit 32
REL_local 64

Let's make it easy on ourselves and use the existing
space.

Regards,


Ann