[Noalyss-commit] [noalyss] 108/323: Remove grant / revoke command

[Dany De Bontridder]

sparkyx pushed a commit to branch master
in repository noalyss.

commit bb3f13ef8b6e44e6a97f8abe06eb74afbb743e20
Author: Dany De Bontridder <address@hidden>
Date:   Sun Jan 28 12:01:05 2018 +0100

    Remove grant / revoke command
---
 include/sql/mod1/make-sql | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/include/sql/mod1/make-sql b/include/sql/mod1/make-sql
index 6e9175a..bdc3e2e 100755
--- a/include/sql/mod1/make-sql
+++ b/include/sql/mod1/make-sql
@@ -30,7 +30,7 @@ awk '/COMMENT ON TRIGGER/,/;/ { print $0;}' < schema.sql >> 
constraint.sql
 awk '/CREATE FUNCTION/,/\$\$;/ { print $0;}' < schema.sql > function.sql
 awk '/COMMENT/,/;/ {print $0;}' < schema.sql > comment.sql
 
-sed -i -e "/ALTER TABLE.*/d" -e "/ADD CONSTRAINT/d" -e "/CREATE PROCEDURAL/d" 
-e "/CREATE TRIGGER/d" -e "/COMMENT ON CONSTRAINT/d" -e "/COMMENT ON TRIGGER/d" 
schema.sql
+sed -i -e "/REVOKE /d" -e "/GRANT /d" -e "/ALTER TABLE.*/d" -e "/ADD 
CONSTRAINT/d" -e "/CREATE PROCEDURAL/d" -e "/CREATE TRIGGER/d" -e "/COMMENT ON 
CONSTRAINT/d" -e "/COMMENT ON TRIGGER/d" schema.sql
 
 
 grep setval schema.sql >> sequence.sql