| Message ID | 20201128171738.27894-1-stephen@that.guru |
|---|---|
| State | Accepted |
| Headers | show |
| Series | [stable/2.2] lib: Add update permissions to 'nobody' postgres user | expand |
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
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@that.guru> Suggested-by: Ali Alnubani <alialnu@mellanox.com> Closes: #364 Stable-Only --- lib/sql/grant-all.postgres.sql | 2 ++ 1 file changed, 2 insertions(+)