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/050-rbac-base.sql | 27 ---------------------------
1 files changed, 0 insertions(+), 27 deletions(-)
diff --git a/src/main/resources/db/changelog/050-rbac-base.sql b/src/main/resources/db/changelog/050-rbac-base.sql
index 16a0019..8b98808 100644
--- a/src/main/resources/db/changelog/050-rbac-base.sql
+++ b/src/main/resources/db/changelog/050-rbac-base.sql
@@ -174,33 +174,6 @@
return old;
end; $$;
-create or replace procedure generateRelatedRbacObject(targetTable varchar)
- language plpgsql as $$
-declare
- createInsertTriggerSQL text;
- createDeleteTriggerSQL text;
-begin
- createInsertTriggerSQL = format($sql$
- create trigger createRbacObjectFor_%s_Trigger
- before insert
- on %s
- for each row
- execute procedure insertRelatedRbacObject();
- $sql$, targetTable, targetTable);
- execute createInsertTriggerSQL;
-
- createDeleteTriggerSQL = format($sql$
- create trigger deleteRbacRulesFor_%s_Trigger
- before delete
- on %s
- for each row
- execute procedure deleteRelatedRbacObject();
- $sql$, targetTable, targetTable);
- execute createDeleteTriggerSQL;
-end; $$;
-
---//
-
-- ============================================================================
--changeset rbac-base-ROLE:1 endDelimiter:--//
--
Gitblit v1.9.3