SQL: Fix adding vndb_multi role and grant on rlists

2 files changed, 4 insertions, 1 deletions

diff --git a/util/sql/perms.sql b/util/sql/perms.sql
index 015cc045..3857d179 100644
--- a/util/sql/perms.sql
+++ b/util/sql/perms.sql
@@ -110,6 +110,7 @@ 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, INSERT, UPDATE, DELETE ON relgraphs                TO vndb_multi;
+GRANT SELECT, INSERT, UPDATE, DELETE ON rlists                   TO vndb_multi;
 GRANT SELECT                         ON screenshots              TO vndb_multi;
 GRANT SELECT (lastused)              ON sessions                 TO vndb_multi;
 GRANT                         DELETE ON sessions                 TO vndb_multi;
diff --git a/util/sql/superuser_init.sql b/util/sql/superuser_init.sql
index 145ff30e..1a2602cd 100644
--- a/util/sql/superuser_init.sql
+++ b/util/sql/superuser_init.sql
@@ -1,5 +1,5 @@
 -- This script should be run before all other scripts and as a PostgreSQL
--- superuser It will create the VNDB database and required users.
+-- superuser. It will create the VNDB database and required users.
 -- All other SQL scripts should be run by the 'vndb' user.
 
 -- In order to "activate" a user, i.e. to allow login, you need to manually run
@@ -11,3 +11,5 @@ CREATE DATABASE vndb OWNER vndb;
 
 -- The website
 CREATE ROLE vndb_site;
+-- Multi
+CREATE ROLE vndb_multi;