summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2020-08-28 09:22:54 +0200
committerYorhel <git@yorhel.nl>2020-08-28 09:22:54 +0200
commit9ec3e32bea6e2a1f2ccc44931d4a2a2c3135c8d9 (patch)
treeb066b872c351393cc49e080ad7da19b3d745c2bd
parent08ba218b728e9db232dfeec8ba2089425820a684 (diff)
SQL/perms: Allow Multi to read update reviews for maintenance query
-rw-r--r--sql/perms.sql3
1 files changed, 3 insertions, 0 deletions
diff --git a/sql/perms.sql b/sql/perms.sql
index 33210c75..bf7cb1a7 100644
--- a/sql/perms.sql
+++ b/sql/perms.sql
@@ -139,6 +139,9 @@ GRANT SELECT ON releases_media TO vndb_multi;
GRANT SELECT ON releases_platforms TO vndb_multi;
GRANT SELECT ON releases_producers TO vndb_multi;
GRANT SELECT ON releases_vn TO vndb_multi;
+GRANT SELECT UPDATE ON reviews TO vndb_site;
+GRANT SELECT ON reviews_posts TO vndb_site;
+GRANT SELECT ON reviews_votes TO vndb_site;
GRANT SELECT, INSERT, UPDATE, DELETE ON rlists TO vndb_multi;
GRANT SELECT (expires) ON sessions TO vndb_multi;
GRANT DELETE ON sessions TO vndb_multi;