From e90149661bbe11684e73cd05f5ed1bce084a2c55 Mon Sep 17 00:00:00 2001 From: "Karl O. Pinc" Date: Sun, 10 Sep 2023 19:18:04 -0500 Subject: [PATCH] Grant permissions to sequences --- db/schemas/sokwedb/tables/create/comm_memb_log.m4 | 1 + db/schemas/sokwedb/tables/create/comm_membs.m4 | 1 + 2 files changed, 2 insertions(+) diff --git a/db/schemas/sokwedb/tables/create/comm_memb_log.m4 b/db/schemas/sokwedb/tables/create/comm_memb_log.m4 index 534692d..f76aae7 100644 --- a/db/schemas/sokwedb/tables/create/comm_memb_log.m4 +++ b/db/schemas/sokwedb/tables/create/comm_memb_log.m4 @@ -41,3 +41,4 @@ CREATE TABLE comm_memb_log ( ); grant_priv(`COMM_MEMBS') +grant_seq_priv(`COMM_MEMB_LOG', `CommMLID') diff --git a/db/schemas/sokwedb/tables/create/comm_membs.m4 b/db/schemas/sokwedb/tables/create/comm_membs.m4 index 54ddb60..80cca36 100644 --- a/db/schemas/sokwedb/tables/create/comm_membs.m4 +++ b/db/schemas/sokwedb/tables/create/comm_membs.m4 @@ -41,3 +41,4 @@ CREATE TABLE comm_membs ( ); grant_priv(`COMM_MEMBS') +grant_seq_priv(`COMM_MEMBS', `CommMID') -- 2.34.1