Access rights for supertypes and subtypes

Previous Next

Access rights on subtypes require special consideration. For example:

It makes no sense to give users INSERT rights on a subtype if they do not also have INSERT rights on mandatory columns of the supertype, since these are mandatory also for the subtype.

Conditions placed on table rights for subtype tables could implicitly apply to the supertype as well.

Subtype indicator columns are part of the supertype table. Access rights on subtype indicator columns are separate from access rights on subtype columns, but must be functionally consistent with them.



collapseHow INSERTs into subtype constellations are authorised
collapseHow DELETEs from subtype constellations are authorised
collapseHow UPDATEs to subtype constellations are authorised




See also

Tables in roles