• Home
• fr.maif
• izanami_2.13
• 2.4.3
• source code
• V3__create_user_tenant_right_table.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

sql.globals.V3__create_user_tenant_right_table.sql Maven / Gradle / Ivy

CREATE TYPE RIGHT_LEVEL AS ENUM ('READ', 'WRITE', 'ADMIN');

CREATE TABLE users_tenants_rights (
    username TEXT NOT NULL REFERENCES users(username) ON DELETE CASCADE ON UPDATE CASCADE,
    tenant TEXT NOT NULL REFERENCES tenants(name) ON DELETE CASCADE ON UPDATE CASCADE,
    level RIGHT_LEVEL NOT NULL DEFAULT 'READ',
    PRIMARY KEY (username, tenant)
);