[PATCH][stable/2.2] lib: Add update permissions to 'nobody' postgres user
Stephen Finucane
stephen at that.guru
Sun Nov 29 04:17:38 AEDT 2020
This user needs the ability to change some attributes of 'Patch' and
'CoverLetter' instances that are stored in the 'patchwork_submission'
table, since both are are concrete subclasses of 'Submission'.
Stable-only since the 'Submission model has been removed on 'master'.
Signed-off-by: Stephen Finucane <stephen at that.guru>
Suggested-by: Ali Alnubani <alialnu at mellanox.com>
Closes: #364
Stable-Only
---
lib/sql/grant-all.postgres.sql | 2 ++
1 file changed, 2 insertions(+)
diff --git lib/sql/grant-all.postgres.sql lib/sql/grant-all.postgres.sql
index 56a24864..48acf1b0 100644
--- lib/sql/grant-all.postgres.sql
+++ lib/sql/grant-all.postgres.sql
@@ -73,6 +73,8 @@ GRANT INSERT, SELECT ON
patchwork_coverletter,
patchwork_event,
patchwork_seriesreference,
+TO "nobody";
+GRANT INSERT, SELECT, UPDATE ON
patchwork_submission
TO "nobody";
GRANT INSERT, SELECT, UPDATE, DELETE ON
--
2.28.0
More information about the Patchwork
mailing list