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