From 360c8e7e79c95a5d3b0bb3690c9682e15246b5bf Mon Sep 17 00:00:00 2001 From: Ali Alnubani Date: Tue, 1 Aug 2023 11:15:35 +0300 Subject: [PATCH] lib: add missing permissions for patchwork_covercomment_id_seq Grants UPDATE and SELECT privileges on patchwork_covercomment_id_seq table for user 'nobody' to fix the following exception when cover comments are being parsed: django.db.utils.ProgrammingError: permission denied for sequence patchwork_covercomment_id_seq Signed-off-by: Ali Alnubani (cherry picked from commit 3ede6b34618d2553ecdaf7f29426a4456c2b47ae) --- lib/sql/grant-all.postgres.sql | 1 + 1 file changed, 1 insertion(+) diff --git a/lib/sql/grant-all.postgres.sql b/lib/sql/grant-all.postgres.sql index e89635fc..8aa6554f 100644 --- a/lib/sql/grant-all.postgres.sql +++ b/lib/sql/grant-all.postgres.sql @@ -94,6 +94,7 @@ TO "nobody"; GRANT UPDATE, SELECT ON patchwork_comment_id_seq, patchwork_cover_id_seq, + patchwork_covercomment_id_seq, patchwork_event_id_seq, patchwork_patch_id_seq, patchwork_patchtag_id_seq, -- 2.47.3