From 77c62700505ceea96f459d328baf0a9fd69be7dd Mon Sep 17 00:00:00 2001 From: adamch Date: Mon, 19 Feb 2007 15:56:03 +0000 Subject: [PATCH] Change granter.sh to give permissions to user specified on command line --- granter.sh | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) diff --git a/granter.sh b/granter.sh index fa2f950..810d382 100755 --- 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" -- 2.20.1