From 89e321e3e8ac4c280890cc28871f17eeae01384c Mon Sep 17 00:00:00 2001
From: Michael Hierweck <michael@hierweck.de>
Date: Sat, 09 Jun 2018 11:51:46 +0200
Subject: [PATCH] MyySQL: GRANT WITH GRANT OPTION when updating db owner.

---
 hsarback/src/de/hsadmin/mods/db/MySqlDatabaseProcessorFactory.java |    2 +-
 1 files changed, 1 insertions(+), 1 deletions(-)

diff --git a/hsarback/src/de/hsadmin/mods/db/MySqlDatabaseProcessorFactory.java b/hsarback/src/de/hsadmin/mods/db/MySqlDatabaseProcessorFactory.java
index 1162139..a24635b 100644
--- a/hsarback/src/de/hsadmin/mods/db/MySqlDatabaseProcessorFactory.java
+++ b/hsarback/src/de/hsadmin/mods/db/MySqlDatabaseProcessorFactory.java
@@ -47,7 +47,7 @@
 		String aOwner = AbstractEntity.escapeString(db.getOwner());
 		JDBCProcessor aJDBCP = null;
 		aJDBCP = createMySqlAdminProcessor();
-		aJDBCP.addSQL("GRANT ALL ON " + aName + ".* TO '" + aOwner + "'@'%'");
+		aJDBCP.addSQL("GRANT ALL ON " + aName + ".* TO '" + aOwner + "'@'%' WITH GRANT OPTION");
 		return aJDBCP;
 	}
 

--
Gitblit v1.9.0-SNAPSHOT