Firebird 6.0.0 inconsistencies re rdb$object_type 38 (SCHEMA)

[tonne1]

Build 2074:

1. The record for rdb$object_type 38 ("SCHEMA") is missing in rdb$types.
2. The owner of the database is explicitly granted usage on schemas "SYSTEM" and "PUBLIC", as can be seen in rdb$user_privileges, although the docs state that both schemas have a default usage permission granted to "PUBLIC".

No big deal if this is intended and as designed, but makes workarounds necessary in tools which extract grant info from these system tables.

[mrotteveel]

Why do you consider point 2 an issue? The owner has explicit permission, so they can still use the object they own even if the permission granted to PUBLIC is revoked.

[mrotteveel]

The documentation also says

A schema, like other database objects, has an owner. The schema owner can manage and use any object within the schema, including objects created by other users in that schema.

[tonne1]

Why do you consider point 2 an issue? The owner has explicit permission, so they can still use the object they own even if the permission granted to PUBLIC is revoked.

That's true and makes sense for schema PUBLIC.

The usage permission on schema SYSTEM for OWNER and user PUBLIC has no grantor (rdb$grantor is null), so OWNER cannot revoke either. The owner of an object has privileges to it, which is already expressed by granting schema SYSTEM to PUBLIC, but the additional explicit grant to OWNER makes this more clear.