svn commit - mysqldoc@docsrva: r15760 - trunk/dynamic-docs/changelog

[anthony.bedford]

Author: tbedford
Date: 2009-07-20 16:17:17 +0200 (Mon, 20 Jul 2009)
New Revision: 15760

Log:
An entry was added for dev bug #41717

Modified:
   trunk/dynamic-docs/changelog/monitor.xml


Modified: trunk/dynamic-docs/changelog/monitor.xml
===================================================================
--- trunk/dynamic-docs/changelog/monitor.xml	2009-07-20 13:44:49 UTC (rev 15759)
+++ trunk/dynamic-docs/changelog/monitor.xml	2009-07-20 14:17:17 UTC (rev 15760)
Changed blocks: 1, Lines Added: 46, Lines Deleted: 0; 1553 bytes

@@ -6,6 +6,52 @@
 ]>
 <changelog>
 
+  <logentry entrytype="bug">
+
+    <bugs>
+      <fixes bugid="41717"/>
+    </bugs>
+
+    <versions>
+      <version ver="2.1.0"/>
+    </versions>
+
+    <message>
+
+      <para>
+        The advisor <quote>User Has Rights To Database That Does Not
+        Exist</quote> generated erroneous alerts.
+      </para>
+
+      <para>
+        If a database was created with an <quote>_</quote> character in
+        the name, and then user privileges granted to this database
+        using the escaped character sequence <quote>\_</quote> to
+        prevent wildcards, then the advisor generates an error stating
+        there is no database for the privilege.
+      </para>
+
+      <para>
+        For example, if the following is carried out on the monitored
+        server:
+      </para>
+
+<programlisting>CREATE DATABASE test_foo;
+GRANT SELECT ON `test\_foo`.* to testuser@'localhost' identified by 'test';</programlisting>
+
+      <para>
+        then the advisor warns that these users have rights to a
+        database that does not exist:
+      </para>
+
+<programlisting>''@'%' on DB test_%,
+'test'@'localhost' on DB test_foo,
+'testuser'@'localhost' on DB test_foo</programlisting>
+
+    </message>
+
+  </logentry>
+
   <logentry entrytype="feature">
 
     <bugs>