-- give necessary permissions to the web server. Becuase the admin is all
-- web-based, these need to be quite permissive
GRANT SELECT, UPDATE, INSERT, DELETE ON
- auth_message,
django_session,
django_site,
django_admin_log,
patchwork_bundlepatch,
patchwork_patch,
patchwork_emailoptout,
- patchwork_patchchangenotification
+ patchwork_patchchangenotification,
+ patchwork_tag,
+ patchwork_patchtag
TO "www-data";
GRANT SELECT, UPDATE ON
auth_group_id_seq,
auth_group_permissions_id_seq,
- auth_message_id_seq,
auth_permission_id_seq,
auth_user_groups_id_seq,
auth_user_id_seq,
patchwork_state_id_seq,
patchwork_emailconfirmation_id_seq,
patchwork_userprofile_id_seq,
- patchwork_userprofile_maintainer_projects_id_seq
+ patchwork_userprofile_maintainer_projects_id_seq,
+ patchwork_tag_id_seq,
+ patchwork_patchtag_id_seq
TO "www-data";
-- allow the mail user (in this case, 'nobody') to add patches
patchwork_comment,
patchwork_person
TO "nobody";
+GRANT INSERT, SELECT, UPDATE, DELETE ON
+ patchwork_patchtag
+TO "nobody";
GRANT SELECT ON
patchwork_project,
- patchwork_state
+ patchwork_state,
+ patchwork_tag
TO "nobody";
GRANT UPDATE, SELECT ON
patchwork_patch_id_seq,
patchwork_person_id_seq,
- patchwork_comment_id_seq
+ patchwork_comment_id_seq,
+ patchwork_patchtag_id_seq
TO "nobody";
COMMIT;