From f7bb805037d7d8710a0b025536616ef9cdfd4cef Mon Sep 17 00:00:00 2001 From: Ali Alnubani Date: Tue, 20 Jun 2023 14:06:07 +0300 Subject: [PATCH] lib: add missing permissions for patchwork_comment_id_seq Grants UPDATE and SELECT privileges on patchwork_comment_id_seq table for web and mail users to fix the following exception when comments are parsed: django.db.utils.ProgrammingError: permission denied for sequence patchwork_comment_id_seq Fixes: 5b53f46def5f ("lib: fix table names") Signed-off-by: Ali Alnubani --- lib/sql/grant-all.postgres.sql | 2 ++ 1 file changed, 2 insertions(+) diff --git a/lib/sql/grant-all.postgres.sql b/lib/sql/grant-all.postgres.sql index baaad22b..5a89d6b2 100644 --- a/lib/sql/grant-all.postgres.sql +++ b/lib/sql/grant-all.postgres.sql @@ -49,6 +49,7 @@ GRANT SELECT, UPDATE ON patchwork_bundle_id_seq, patchwork_bundlepatch_id_seq, patchwork_check_id_seq, + patchwork_comment_id_seq, patchwork_cover_id_seq, patchwork_covercomment_id_seq, patchwork_delegationrule_id_seq, @@ -91,6 +92,7 @@ GRANT SELECT ON patchwork_tag TO "nobody"; GRANT UPDATE, SELECT ON + patchwork_comment_id_seq, patchwork_event_id_seq, patchwork_patch_id_seq, patchwork_patchtag_id_seq, -- 2.47.3