X-Git-Url: http://git.hcoop.net/hcoop/portal.git/blobdiff_plain/a6e7d7eda652575623fd558392db474fa997c0d6..a0399d9eb81953e028a4a2a04f3ccecfe6ac087b:/granter.sh

diff --git a/granter.sh b/granter.sh
index fa2f950..810d382 100755
--- a/granter.sh
+++ b/granter.sh
@@ -1,6 +1,6 @@
 #!/bin/sh
 
 grep "CREATE" tables.sql \
-    | sed 's/^CREATE TABLE \(.*\)($/GRANT SELECT,UPDATE,INSERT,DELETE ON \1 TO "www-data";/g' \
-    | sed 's/^CREATE VIEW \(.*\)$/GRANT SELECT,UPDATE,INSERT,DELETE ON \1 TO "www-data";/g' \
-    | sed 's/^CREATE SEQUENCE \(.*\) START.*$/GRANT SELECT,UPDATE,INSERT,DELETE ON \1 TO "www-data";/g'
+    | sed "s/^CREATE TABLE \(.*\)($/GRANT SELECT,UPDATE,INSERT,DELETE ON \1 TO \"$1\";/g" \
+    | sed "s/^CREATE VIEW \(.*\)$/GRANT SELECT,UPDATE,INSERT,DELETE ON \1 TO \"$1\";/g" \
+    | sed "s/^CREATE SEQUENCE \(.*\) START.*$/GRANT SELECT,UPDATE,INSERT,DELETE ON \1 TO \"$1\";/g"