We need access to Check & Delegationrule.
Signed-off-by: Jeremy Kerr <[email protected]>
---
lib/sql/grant-all.mysql.sql | 3 +++
lib/sql/grant-all.postgres.sql | 11 ++++++++---
2 files changed, 11 insertions(+), 3 deletions(-)
diff --git a/lib/sql/grant-all.mysql.sql b/lib/sql/grant-all.mysql.sql
index 6a3d547..1220c8e 100644
--- a/lib/sql/grant-all.mysql.sql
+++ b/lib/sql/grant-all.mysql.sql
@@ -25,6 +25,8 @@ GRANT SELECT, UPDATE, INSERT, DELETE ON patchwork_emailoptout
TO 'www-data'@loca
GRANT SELECT, UPDATE, INSERT, DELETE ON patchwork_patchchangenotification TO
'www-data'@localhost;
GRANT SELECT, UPDATE, INSERT, DELETE ON patchwork_tag TO 'www-data'@localhost;
GRANT SELECT, UPDATE, INSERT, DELETE ON patchwork_patchtag TO
'www-data'@localhost;
+GRANT SELECT, UPDATE, INSERT, DELETE ON patchwork_check TO
'www-data'@localhost;
+GRANT SELECT, UPDATE, INSERT, DELETE ON patchwork_delegationrule TO
'www-data'@localhost;
-- allow the mail user (in this case, 'nobody') to add patches
GRANT INSERT, SELECT ON patchwork_patch TO 'nobody'@localhost;
@@ -34,6 +36,7 @@ GRANT INSERT, SELECT, UPDATE, DELETE ON patchwork_patchtag TO
'nobody'@localhost
GRANT SELECT ON patchwork_project TO 'nobody'@localhost;
GRANT SELECT ON patchwork_state TO 'nobody'@localhost;
GRANT SELECT ON patchwork_tag TO 'nobody'@localhost;
+GRANT SELECT ON patchwork_delegationrule TO 'nobody'@localhost;
COMMIT;
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,
--
2.5.0
_______________________________________________
Patchwork mailing list
[email protected]
https://lists.ozlabs.org/listinfo/patchwork
