granter.sh

   1 #!/bin/sh
   2
   3 grep "CREATE" tables.sql \
   4     | sed "s/^CREATE TABLE \(.*\)($/GRANT SELECT,UPDATE,INSERT,DELETE ON \1 TO \"$1\";/g" \
   5     | sed "s/^CREATE VIEW \(.*\)$/GRANT SELECT,UPDATE,INSERT,DELETE ON \1 TO \"$1\";/g" \
   6     | sed "s/^CREATE SEQUENCE \(.*\) START.*$/GRANT SELECT,UPDATE,INSERT,DELETE ON \1 TO \"$1\";/g"