Change granter.sh to give permissions to user specified on command line

diff --git a/granter.sh b/granter.sh
index fa2f950..810d382 100755 (executable)
--- 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"