X-Git-Url: http://git.hcoop.net/bpt/portal.git/blobdiff_plain/a6e7d7eda652575623fd558392db474fa997c0d6..c4c9e7706d103af80dd7f474f77f4899aa193a9f:/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"