diff options
Diffstat (limited to 'lib/sql/grant-all.postgres.sql')
-rw-r--r-- | lib/sql/grant-all.postgres.sql | 24 |
1 files changed, 13 insertions, 11 deletions
diff --git a/lib/sql/grant-all.postgres.sql b/lib/sql/grant-all.postgres.sql index 56a2486..a85326e 100644 --- a/lib/sql/grant-all.postgres.sql +++ b/lib/sql/grant-all.postgres.sql @@ -16,14 +16,15 @@ GRANT SELECT, UPDATE, INSERT, DELETE ON patchwork_bundle, patchwork_bundlepatch, patchwork_check, - patchwork_comment, - patchwork_coverletter, + patchwork_cover, + patchwork_covercomment, patchwork_delegationrule, patchwork_emailconfirmation, patchwork_emailoptout, patchwork_event, patchwork_patch, patchwork_patchchangenotification, + patchwork_patchcomment, patchwork_patchrelation, patchwork_patchtag, patchwork_person, @@ -31,7 +32,6 @@ GRANT SELECT, UPDATE, INSERT, DELETE ON patchwork_series, patchwork_seriesreference, patchwork_state, - patchwork_submission, patchwork_tag, patchwork_userprofile, patchwork_userprofile_maintainer_projects @@ -49,11 +49,13 @@ 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, patchwork_emailconfirmation_id_seq, patchwork_event_id_seq, patchwork_patch_id_seq, + patchwork_patchcomment_id_seq, patchwork_patchrelation_id_seq, patchwork_patchtag_id_seq, patchwork_person_id_seq, @@ -66,14 +68,15 @@ GRANT SELECT, UPDATE ON patchwork_userprofile_maintainer_projects_id_seq TO "www-data"; --- allow the mail user (in this case, 'nobody') to add submissions (patches, --- cover letters) and series +-- allow the mail user (in this case, 'nobody') to add patches +-- cover letters, their respective comments, and series GRANT INSERT, SELECT ON - patchwork_comment, - patchwork_coverletter, + patchwork_cover, + patchwork_covercomment, + patchwork_patch, + patchwork_patchcomment, patchwork_event, - patchwork_seriesreference, - patchwork_submission + patchwork_seriesreference TO "nobody"; GRANT INSERT, SELECT, UPDATE, DELETE ON patchwork_patch, @@ -88,7 +91,6 @@ 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, |