From 7376301ed44726f483af74ef4bd881463d7ea4a9 Mon Sep 17 00:00:00 2001
From: Michael Hoennig <michael@hoennig.de>
Date: Wed, 19 Oct 2022 07:39:10 +0200
Subject: [PATCH] use lower case in audit-log and rbac tables
---
src/main/resources/db/changelog/058-rbac-generators.sql | 4 ++++
1 files changed, 4 insertions(+), 0 deletions(-)
diff --git a/src/main/resources/db/changelog/058-rbac-generators.sql b/src/main/resources/db/changelog/058-rbac-generators.sql
index ab20937..8268502 100644
--- a/src/main/resources/db/changelog/058-rbac-generators.sql
+++ b/src/main/resources/db/changelog/058-rbac-generators.sql
@@ -97,6 +97,8 @@
declare
sql text;
begin
+ targettable := lower(targettable);
+
-- create a view to the target main table which maps an idName to the objectUuid
sql = format($sql$
create or replace view %1$s_iv as
@@ -140,6 +142,8 @@
declare
sql text;
begin
+ targetTable := lower(targetTable);
+
/*
Creates a restricted view based on the 'view' permission of the current subject.
*/
--
Gitblit v1.9.3