diff options
| author | Jeremy Kerr <jk@ozlabs.org> | 2016-03-27 12:53:05 +0800 |
|---|---|---|
| committer | Stephen Finucane <stephen.finucane@intel.com> | 2016-03-29 09:54:33 +0100 |
| commit | e499cc7c24f712c323c204029e947ca41dcf1c0d (patch) | |
| tree | 1517a30fedf3b9ae492ec1f18b031259d82f543e /lib/sql | |
| parent | f0c10b90756e8fe902f1c743a0ae4460f39582be (diff) | |
| download | patchwork-e499cc7c24f712c323c204029e947ca41dcf1c0d.tar patchwork-e499cc7c24f712c323c204029e947ca41dcf1c0d.tar.gz | |
Update permissions on grant-all scripts
We need access to Check & Delegationrule.
Signed-off-by: Jeremy Kerr <jk@ozlabs.org>
Acked-by: Stephen Finucane <stephen.finucane@intel.com>
Diffstat (limited to 'lib/sql')
| -rw-r--r-- | lib/sql/grant-all.mysql.sql | 3 | ||||
| -rw-r--r-- | 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, |