X-Git-Url: https://git.ozlabs.org/?a=blobdiff_plain;f=lib%2Fsql%2Fgrant-all.postgres.sql;h=926d5d3baede01ef82119a8b0c6c6e670f2440b1;hb=02550731a4b37a7f42c1158afa0c2f7dd3cdb484;hp=47c4ad3fcd0fe3bf7cd4b4c0c564bd12d7244102;hpb=56e2243f3be7e859666ce0e4e1a8b8b94444f8d4;p=patchwork diff --git a/lib/sql/grant-all.postgres.sql b/lib/sql/grant-all.postgres.sql index 47c4ad3..926d5d3 100644 --- a/lib/sql/grant-all.postgres.sql +++ b/lib/sql/grant-all.postgres.sql @@ -23,7 +23,8 @@ GRANT SELECT, UPDATE, INSERT, DELETE ON patchwork_bundle, patchwork_bundlepatch, patchwork_patch, - registration_registrationprofile + patchwork_emailoptout, + patchwork_patchchangenotification TO "www-data"; GRANT SELECT, UPDATE ON auth_group_id_seq, @@ -45,8 +46,7 @@ GRANT SELECT, UPDATE ON patchwork_state_id_seq, patchwork_emailconfirmation_id_seq, patchwork_userprofile_id_seq, - patchwork_userprofile_maintainer_projects_id_seq, - registration_registrationprofile_id_seq + patchwork_userprofile_maintainer_projects_id_seq TO "www-data"; -- allow the mail user (in this case, 'nobody') to add patches