connectivity/source/drivers/mysql/YCatalog.cxx | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
New commits:
commit d1bc27c2aa49b3ed3526a27c4713c708ca6401f4
Author: Julien Nabet <serval2...@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 <lio...@mamane.lu>
Tested-by: Lionel Elie Mamane <lio...@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);
_______________________________________________
Libreoffice-commits mailing list
libreoffice-comm...@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
