From 888667a8270f3088954d85d1fdddb9b30e84a7f5 Mon Sep 17 00:00:00 2001 From: Ludovic CHEVALIER Date: Thu, 26 Sep 2013 12:06:59 +0200 Subject: [PATCH] Corrections : etc/sv/openerp_cyclofficines/local.sh --- etc/sv/openerp_cyclofficines/local.sh | 21 ++++++++++----------- 1 file changed, 10 insertions(+), 11 deletions(-) diff --git a/etc/sv/openerp_cyclofficines/local.sh b/etc/sv/openerp_cyclofficines/local.sh index e6887a3..dc04c3c 100644 --- a/etc/sv/openerp_cyclofficines/local.sh +++ b/etc/sv/openerp_cyclofficines/local.sh @@ -42,19 +42,18 @@ for db in \ sudo install -d -m 750 -o "$sv" -g "$sv" \ "$home"/etc \ /etc/openerp/"$db" + sudo -u postgres psql -AqtX "$db" <<-EOF + \set ON_ERROR_STOP on + GRANT USAGE ON SCHEMA pg_catalog TO $sv; + GRANT SELECT ON TABLE pg_catalog.pg_attribute TO $sv; + GRANT SELECT ON TABLE pg_catalog.pg_class TO $sv; + GRANT SELECT ON TABLE pg_catalog.pg_constraint TO $sv; + GRANT SELECT ON TABLE pg_catalog.pg_indexes TO $sv; + GRANT SELECT ON TABLE pg_catalog.pg_proc TO $sv; + GRANT SELECT ON TABLE pg_catalog.pg_type TO $sv; + EOF done -sudo -u postgres psql -AqtX "$sv" <<-EOF - \set ON_ERROR_STOP on - GRANT USAGE ON SCHEMA pg_catalog TO $sv; - GRANT SELECT ON TABLE pg_catalog.pg_attribute TO $sv; - GRANT SELECT ON TABLE pg_catalog.pg_class TO $sv; - GRANT SELECT ON TABLE pg_catalog.pg_constraint TO $sv; - GRANT SELECT ON TABLE pg_catalog.pg_indexes TO $sv; - GRANT SELECT ON TABLE pg_catalog.pg_proc TO $sv; - GRANT SELECT ON TABLE pg_catalog.pg_type TO $sv; - EOF - sudo adduser git "$sv"-addon sudo adduser "$sv" "$sv"-addon sudo adduser "$sv" postgres-data -- 2.20.1