Manitou-Mail Home

13.  Table: identities_permissions

This table maps the relationship between identities and the user accounts that are allowed to access the messages associated to these identities through the mail.identity_id column. It does not indicate what access rights apply, the permissions being managed separately by group permissions and membership. Only identities that have the restricted attribute are concerned by this mapping. The restrictions also require the Row Level Security feature on the database server (PostgreSQL 9.5 or newer).

Structure of identities_permissions

role_oid

oid

Reference to the PostgreSQL role, through the cluster-wide pg_roles table.

identity_id

int

Identity of messages that are accessible by that role.

REFERENCES identities