diff options
Diffstat (limited to 'lib/sql/grant-all.postgres.sql')
| -rw-r--r-- | lib/sql/grant-all.postgres.sql | 11 |
1 files changed, 8 insertions, 3 deletions
diff --git a/lib/sql/grant-all.postgres.sql b/lib/sql/grant-all.postgres.sql index 477e10a..68ff9f1 100644 --- a/lib/sql/grant-all.postgres.sql +++ b/lib/sql/grant-all.postgres.sql @@ -25,7 +25,9 @@ GRANT SELECT, UPDATE, INSERT, DELETE ON patchwork_emailoptout, patchwork_patchchangenotification, patchwork_tag, - patchwork_patchtag + patchwork_patchtag, + patchwork_check, + patchwork_delegationrule TO "www-data"; GRANT SELECT, UPDATE ON auth_group_id_seq, @@ -48,7 +50,9 @@ GRANT SELECT, UPDATE ON patchwork_userprofile_id_seq, patchwork_userprofile_maintainer_projects_id_seq, patchwork_tag_id_seq, - patchwork_patchtag_id_seq + patchwork_patchtag_id_seq, + patchwork_check_id_seq, + patchwork_delegationrule_id_seq TO "www-data"; -- allow the mail user (in this case, 'nobody') to add patches @@ -63,7 +67,8 @@ TO "nobody"; GRANT SELECT ON patchwork_project, patchwork_state, - patchwork_tag + patchwork_tag, + patchwork_delegationrule TO "nobody"; GRANT UPDATE, SELECT ON patchwork_patch_id_seq, |