Subject Re: [Firebird-Architect] feature request: embed the security database on each database file
Author Jim Starkey
Dmitry Yemanov wrote:

>>I guess I don't understand why any ODS changes were contemplated or
>>necessary.
>>
>>
>
>Adding new system table (RDB$USERS or alike) is an ODS change.
>
>
>
It needn't be.

The core system tables are those that need to be referenced by id before
the system is sufficiently up to resolve names. This really doesn't
need to be much beyond RDB$PAGES, RDB$RELATIONS, RDB$RELATION_FIELDS,
and RDB$FIELDS plus maybe the index definition guys. Everything else
can be created as ordinary user tables with protections set appropriately.

In any case, a table RDB$USERS would belong to the security manager, not
the engine. Defining it was part of the engine violates the layering.


[Non-text portions of this message have been removed]