diff options
author | Yorhel <git@yorhel.nl> | 2022-06-25 11:36:06 +0200 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2022-06-25 11:36:08 +0200 |
commit | d0cb00ebcab143f44252d1f1ada9a12bf7d5254c (patch) | |
tree | 9e98e7a431c7bb7ab52b53dfe25c903dda48fc98 /sql | |
parent | d05f2f210d9032ff7f726289a72985a87f0b7c75 (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.sql | 2 |
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; |