summaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2022-06-25 11:36:06 +0200
committerYorhel <git@yorhel.nl>2022-06-25 11:36:08 +0200
commitd0cb00ebcab143f44252d1f1ada9a12bf7d5254c (patch)
tree9e98e7a431c7bb7ab52b53dfe25c903dda48fc98 /sql
parentd05f2f210d9032ff7f726289a72985a87f0b7c75 (diff)
SQL: add permissions to public schema as well
Not really necessary as the "public" schema is accessible by default, but useful when loading into a custom schema.
Diffstat (limited to 'sql')
-rw-r--r--sql/perms.sql2
1 files changed, 2 insertions, 0 deletions
diff --git a/sql/perms.sql b/sql/perms.sql
index 644d1281..0ea27afa 100644
--- a/sql/perms.sql
+++ b/sql/perms.sql
@@ -2,6 +2,7 @@
DROP OWNED BY vndb_site;
GRANT CONNECT, TEMP ON DATABASE :DBNAME TO vndb_site;
+GRANT USAGE ON SCHEMA public TO vndb_site;
GRANT EXECUTE ON ALL FUNCTIONS IN SCHEMA public TO vndb_site;
GRANT USAGE, SELECT ON ALL SEQUENCES IN SCHEMA public TO vndb_site;
@@ -109,6 +110,7 @@ GRANT SELECT, INSERT ON wikidata TO vndb_site;
DROP OWNED BY vndb_multi;
GRANT CONNECT, TEMP ON DATABASE :DBNAME TO vndb_multi;
+GRANT USAGE ON SCHEMA public TO vndb_multi;
GRANT EXECUTE ON ALL FUNCTIONS IN SCHEMA public TO vndb_multi;
GRANT USAGE, SELECT ON ALL SEQUENCES IN SCHEMA public TO vndb_multi;