From d63e3f31e926a53cbfdfb8accda77472ea66e2cc Mon Sep 17 00:00:00 2001 From: Michael Hoennig <michael@hoennig.de> Date: Fri, 16 Sep 2022 15:25:58 +0200 Subject: [PATCH] introduce 058-rbac-generators.sql with generateRelatedRbacObject+generateRbacRoleDescriptors --- src/main/resources/db/changelog/213-hs-office-person-rbac.sql | 26 +------------------------- 1 files changed, 1 insertions(+), 25 deletions(-) diff --git a/src/main/resources/db/changelog/213-hs-office-person-rbac.sql b/src/main/resources/db/changelog/213-hs-office-person-rbac.sql index ccf3767..c7ab28e 100644 --- a/src/main/resources/db/changelog/213-hs-office-person-rbac.sql +++ b/src/main/resources/db/changelog/213-hs-office-person-rbac.sql @@ -1,6 +1,5 @@ --liquibase formatted sql - -- ============================================================================ --changeset hs-office-person-rbac-OBJECT:1 endDelimiter:--// -- ---------------------------------------------------------------------------- @@ -11,30 +10,7 @@ -- ============================================================================ --changeset hs-office-person-rbac-ROLE-DESCRIPTORS:1 endDelimiter:--// -- ---------------------------------------------------------------------------- - -create or replace function hsOfficePersonOwner(person hs_office_person) - returns RbacRoleDescriptor - language plpgsql - strict as $$ -begin - return roleDescriptor('hs_office_person', person.uuid, 'owner'); -end; $$; - -create or replace function hsOfficePersonAdmin(person hs_office_person) - returns RbacRoleDescriptor - language plpgsql - strict as $$ -begin - return roleDescriptor('hs_office_person', person.uuid, 'admin'); -end; $$; - -create or replace function hsOfficePersonTenant(person hs_office_person) - returns RbacRoleDescriptor - language plpgsql - strict as $$ -begin - return roleDescriptor('hs_office_person', person.uuid, 'tenant'); -end; $$; +call generateRbacRoleDescriptors('hsOfficePerson', 'hs_office_person'); --// -- Gitblit v1.9.3