X-Git-Url: https://git.ozlabs.org/?a=blobdiff_plain;f=lib%2Fsql%2Fgrant-all.postgres.sql;h=926d5d3baede01ef82119a8b0c6c6e670f2440b1;hb=02550731a4b37a7f42c1158afa0c2f7dd3cdb484;hp=72e1f3195f516d7a431872a1123f787835c4ee4e;hpb=4a039197705f92ee1c362401a7f7bb834ecc9079;p=patchwork diff --git a/lib/sql/grant-all.postgres.sql b/lib/sql/grant-all.postgres.sql index 72e1f31..926d5d3 100644 --- a/lib/sql/grant-all.postgres.sql +++ b/lib/sql/grant-all.postgres.sql @@ -13,7 +13,7 @@ GRANT SELECT, UPDATE, INSERT, DELETE ON auth_group, auth_user_user_permissions, auth_permission, - patchwork_userpersonconfirmation, + patchwork_emailconfirmation, patchwork_state, patchwork_comment, patchwork_person, @@ -21,9 +21,10 @@ GRANT SELECT, UPDATE, INSERT, DELETE ON patchwork_userprofile_maintainer_projects, patchwork_project, patchwork_bundle, - patchwork_bundle_patches, + patchwork_bundlepatch, patchwork_patch, - registration_registrationprofile + patchwork_emailoptout, + patchwork_patchchangenotification TO "www-data"; GRANT SELECT, UPDATE ON auth_group_id_seq, @@ -37,16 +38,15 @@ GRANT SELECT, UPDATE ON django_content_type_id_seq, django_site_id_seq, patchwork_bundle_id_seq, - patchwork_bundle_patches_id_seq, + patchwork_bundlepatch_id_seq, patchwork_comment_id_seq, patchwork_patch_id_seq, patchwork_person_id_seq, patchwork_project_id_seq, patchwork_state_id_seq, - patchwork_userpersonconfirmation_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