diff options
author | Yorhel <git@yorhel.nl> | 2016-12-01 20:08:40 +0100 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2016-12-01 20:08:40 +0100 |
commit | 43cfc24de61854711fc82fd420654bf5ee762f48 (patch) | |
tree | 483cd7ce016f1cf080fbf7b8fcf918e332456ac0 | |
parent | e75c79790ec102d041882479f3c5ebe4985a2ffc (diff) |
SQL: Fix adding vndb_multi role and grant on rlists
-rw-r--r-- | util/sql/perms.sql | 1 | ||||
-rw-r--r-- | util/sql/superuser_init.sql | 4 |
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; |