2 -- give necessary permissions to the web server. Becuase the admin is all
3 -- web-based, these need to be quite permissive
4 GRANT SELECT, UPDATE, INSERT, DELETE ON
9 auth_group_permissions,
13 auth_user_user_permissions,
15 patchwork_emailconfirmation,
19 patchwork_userprofile,
20 patchwork_userprofile_maintainer_projects,
23 patchwork_bundlepatch,
25 patchwork_emailoptout,
26 patchwork_patchchangenotification,
30 GRANT SELECT, UPDATE ON
32 auth_group_permissions_id_seq,
33 auth_permission_id_seq,
34 auth_user_groups_id_seq,
36 auth_user_user_permissions_id_seq,
37 django_admin_log_id_seq,
38 django_content_type_id_seq,
40 patchwork_bundle_id_seq,
41 patchwork_bundlepatch_id_seq,
42 patchwork_comment_id_seq,
43 patchwork_patch_id_seq,
44 patchwork_person_id_seq,
45 patchwork_project_id_seq,
46 patchwork_state_id_seq,
47 patchwork_emailconfirmation_id_seq,
48 patchwork_userprofile_id_seq,
49 patchwork_userprofile_maintainer_projects_id_seq,
51 patchwork_patchtag_id_seq
54 -- allow the mail user (in this case, 'nobody') to add patches
55 GRANT INSERT, SELECT ON
60 GRANT INSERT, SELECT, UPDATE, DELETE ON
68 GRANT UPDATE, SELECT ON
69 patchwork_patch_id_seq,
70 patchwork_person_id_seq,
71 patchwork_comment_id_seq,
72 patchwork_patchtag_id_seq