[hcoop/zz_old/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
a1da81a6	1	#!/bin/sh
	2
	3	grep "CREATE" tables.sql \
77c62700	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"