On 18-4-2015 11:44, Dimitry Sibiryakov sd@...
[Firebird-general] wrote:

> 18.04.2015 10:46, Mark Rotteveel mark@... [Firebird-general] wrote:
>> In other words, according to the SQL standard the owner of the table is
>> the owner of the schema it is created in. There is no other transfer of
>> ownership than transferring ownership of the schema.
>
> BTW, doesn't it mean that to implement schemata in Firebird it is enough to change
> unique check from single field RDB$RELATION_NAME to pair RDB$OWNER,RDB$RELATION_NAME?..
> And, of course, to fix table lookups accordingly.
>

Not really, the fact that a schema is owned by a user, does not mean
that schema and user are an equivalence. There can be more than one
schema owned by a user.

Mark
--
Mark Rotteveel