[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