summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorChristophe Siraut <csiraut@entrouvert.com>2019-06-11 08:41:27 (GMT)
committerChristophe Siraut <csiraut@entrouvert.com>2019-06-11 08:41:27 (GMT)
commit2bd1df4f2a20f7a6a79eb5723a8da34fa7ca76eb (patch)
treeef1a464fa25c0f8f02e67145e8838e8b4fb2402f
parentf7b3c154c0bc0430928bdad6fd9c8d98e8067f0f (diff)
downloadpublik-client-scripts-2bd1df4f2a20f7a6a79eb5723a8da34fa7ca76eb.zip
publik-client-scripts-2bd1df4f2a20f7a6a79eb5723a8da34fa7ca76eb.tar.gz
publik-client-scripts-2bd1df4f2a20f7a6a79eb5723a8da34fa7ca76eb.tar.bz2
montpellier: grant usage on schemas (#32404)v1.5
-rwxr-xr-xclients/montpellier/pg_copy_bijoe_schemas1
1 files changed, 1 insertions, 0 deletions
diff --git a/clients/montpellier/pg_copy_bijoe_schemas b/clients/montpellier/pg_copy_bijoe_schemas
index 72aaa8a..ea6d84c 100755
--- a/clients/montpellier/pg_copy_bijoe_schemas
+++ b/clients/montpellier/pg_copy_bijoe_schemas
@@ -23,4 +23,5 @@ for schema in $schemas
do
pg_dump --no-owner --schema $schema $origin | psql $destination >/dev/null
psql $destination -c "GRANT SELECT ON ALL TABLES IN SCHEMA $schema TO $owner" >/dev/null
+ psql $destination -c "GRANT USAGE ON SCHEMA $schema TO $owner" >/dev/null
done