[hcoop/portal.git] / granter.sh

#!/bin/sh

grep "CREATE" tables.sql \
    | 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"
Commit	Line	Data
a6e7d7ed AC	1	#!/bin/sh
	2
	3	grep "CREATE" tables.sql \
ff56beea AC	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"