diff options
| author | Julien Nabet <serval2412@yahoo.fr> | 2013-12-18 23:14:42 +0100 |
|---|---|---|
| committer | Lionel Elie Mamane <lionel@mamane.lu> | 2014-01-30 15:37:12 +0000 |
| commit | d1bc27c2aa49b3ed3526a27c4713c708ca6401f4 (patch) | |
| tree | fbc9ef5a5fbe378fe936857bf3d3b5f7e6801d22 /connectivity/source | |
| parent | bfefe113f69031ff3c3196858bd8dfd11add44ac (diff) | |
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@mamane.lu>
Tested-by: Lionel Elie Mamane <lionel@mamane.lu>
Diffstat (limited to 'connectivity/source')
| -rw-r--r-- | connectivity/source/drivers/mysql/YCatalog.cxx | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/connectivity/source/drivers/mysql/YCatalog.cxx b/connectivity/source/drivers/mysql/YCatalog.cxx index 3541ea8dd3e5..df97f2db4fcc 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); |