Script to generate SQL GRANT statements for all relations from tables.sql

diff --git a/granter.sh b/granter.sh
new file mode 100755 (executable)
index 0000000..fa2f950
--- /dev/null
+++ b/granter.sh
@@ -0,0 +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'