[Libreoffice-commits] core.git: connectivity/source

[Julien Nabet]

 connectivity/source/drivers/mysql/YCatalog.cxx |    2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

New commits:
commit d1bc27c2aa49b3ed3526a27c4713c708ca6401f4
Author: Julien Nabet <serval2412 at yahoo.fr>
Date:   Wed Dec 18 23:14:42 2013 +0100

    User grants debug Mysql part: first steps
    
    Select all user/host instead of just user
    so we'll have 'root'@'localhost', 'root'@'127.0.0.1', etc. instead of just root
    
    Next step: retrieve IS_GRANTABLE value (so patch mysqlcppconn)
    
    Change-Id: Ib0ce7d0745ace17ce8058f3ff9806bea2bdc56f1
    Reviewed-on: https://gerrit.libreoffice.org/7140
    Reviewed-by: Lionel Elie Mamane <lionel at mamane.lu>
    Tested-by: Lionel Elie Mamane <lionel at mamane.lu>

diff --git a/connectivity/source/drivers/mysql/YCatalog.cxx b/connectivity/source/drivers/mysql/YCatalog.cxx
index 3541ea8..df97f2d 100644
--- a/connectivity/source/drivers/mysql/YCatalog.cxx
+++ b/connectivity/source/drivers/mysql/YCatalog.cxx
@@ -100,7 +100,7 @@ void OMySQLCatalog::refreshUsers()
 {
     TStringVector aVector;
     Reference< XStatement > xStmt = m_xConnection->createStatement(  );
-    Reference< XResultSet >  xResult = xStmt->executeQuery(OUString("select User from mysql.user group by User"));
+    Reference< XResultSet >  xResult = xStmt->executeQuery(OUString("SELECT grantee FROM information_schema.user_privileges GROUP BY grantee"));
     if ( xResult.is() )
     {
         Reference< XRow > xRow(xResult,UNO_QUERY);