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/123-test-package-rbac.sql | 37 +++----------------------------------
1 files changed, 3 insertions(+), 34 deletions(-)
diff --git a/src/main/resources/db/changelog/123-test-package-rbac.sql b/src/main/resources/db/changelog/123-test-package-rbac.sql
index 15cc0d1..585fb6e 100644
--- a/src/main/resources/db/changelog/123-test-package-rbac.sql
+++ b/src/main/resources/db/changelog/123-test-package-rbac.sql
@@ -1,47 +1,16 @@
--liquibase formatted sql
-- ============================================================================
---changeset test-package-rbac-CREATE-OBJECT:1 endDelimiter:--//
+--changeset test-package-rbac-OBJECT:1 endDelimiter:--//
-- ----------------------------------------------------------------------------
-/*
- Creates the related RbacObject through a BEFORE INSERT TRIGGER.
- */
-drop trigger if exists createRbacObjectForPackage_Trigger on test_package;
-create trigger createRbacObjectForPackage_Trigger
- before insert
- on test_package
- for each row
-execute procedure insertRelatedRbacObject();
+call generateRelatedRbacObject('test_package');
--//
-- ============================================================================
--changeset test-package-rbac-ROLE-DESCRIPTORS:1 endDelimiter:--//
-- ----------------------------------------------------------------------------
-
-create or replace function testPackageOwner(pac test_package)
- returns RbacRoleDescriptor
- returns null on null input
- language plpgsql as $$
-begin
- return roleDescriptor('test_package', pac.uuid, 'owner');
-end; $$;
-
-create or replace function testPackageAdmin(pac test_package)
- returns RbacRoleDescriptor
- returns null on null input
- language plpgsql as $$
-begin
- return roleDescriptor('test_package', pac.uuid, 'admin');
-end; $$;
-
-create or replace function testPackageTenant(pac test_package)
- returns RbacRoleDescriptor
- returns null on null input
- language plpgsql as $$
-begin
- return roleDescriptor('test_package', pac.uuid, 'tenant');
-end; $$;
+call generateRbacRoleDescriptors('testPackage', 'test_package');
--//
--
Gitblit v1.9.3