Author: shinz
Date: 2006-09-12 12:46:33 +0200 (Tue, 12 Sep 2006)
New Revision: 3330
Log:
Document privilege-related restrictions on views and mysqldump/views, closing Bug #22063
Modified:
trunk/refman-5.0/client-utility-programs.xml
trunk/refman-5.0/restrictions.xml
trunk/refman-5.1/client-utility-programs.xml
trunk/refman-5.1/restrictions.xml
Modified: trunk/refman-5.0/client-utility-programs.xml
===================================================================
--- trunk/refman-5.0/client-utility-programs.xml 2006-09-12 01:46:47 UTC (rev 3329)
+++ trunk/refman-5.0/client-utility-programs.xml 2006-09-12 10:46:33 UTC (rev 3330)
Changed blocks: 1, Lines Added: 20, Lines Deleted: 1; 1155 bytes
@@ -11423,7 +11423,26 @@
<xref linkend="backup"/>, and
<xref linkend="backup-strategy-example"/>.
</para>
-
+ <indexterm>
+ <primary>mysqldump</primary>
+ <secondary>views</secondary>
+ </indexterm>
+ <indexterm>
+ <primary>mysqldump</primary>
+ <secondary>problems</secondary>
+ </indexterm>
+ <indexterm>
+ <primary>mysqldump</primary>
+ <secondary>workarounds</secondary>
+ </indexterm>
+ <para>
+ If you encounter problems backing up views, please read the
+ section that covers restrictions on views which describes
+ a workaround for backing up views when this fails due to
+ insufficient privileges. See
+ <xref linkend="view-restrictions"/>.
+ </para>
+
</refsection>
</refentry>
Modified: trunk/refman-5.0/restrictions.xml
===================================================================
--- trunk/refman-5.0/restrictions.xml 2006-09-12 01:46:47 UTC (rev 3329)
+++ trunk/refman-5.0/restrictions.xml 2006-09-12 10:46:33 UTC (rev 3330)
Changed blocks: 1, Lines Added: 48, Lines Deleted: 1; 1965 bytes
@@ -945,7 +945,54 @@
</listitem>
</itemizedlist>
-
+ <indexterm>
+ <primary>mysqldump</primary>
+ <secondary>views</secondary>
+ </indexterm>
+ <indexterm>
+ <primary>mysqldump</primary>
+ <secondary>problems</secondary>
+ </indexterm>
+ <indexterm>
+ <primary>mysqldump</primary>
+ <secondary>workarounds</secondary>
+ </indexterm>
+ <indexterm>
+ <primary>Views</primary>
+ <secondary>limitations</secondary>
+ </indexterm>
+ <indexterm>
+ <primary>Views</primary>
+ <secondary>problems</secondary>
+ </indexterm>
+ <indexterm>
+ <primary>Views</primary>
+ <secondary>privileges</secondary>
+ </indexterm>
+
+ <para>
+ There exists a shortcoming with the current implementation of
+ views. If a user is granted the basic privileges necessary to
+ create a view (the <literal>CREATE VIEW</literal> and
+ <literal>SELECT</literal> privileges), that user will be unable
+ to call <literal>SHOW CREATE VIEW</literal> on that object unless
+ the user is also granted the <literal>SHOW VIEW</literal>
+ privilege.
+ </para>
+
+ <para>
+ That shortcoming can lead to problems backing up a database with
+ <command>mysqldump</command>, which may fail due to insufficient
+ privileges. This problem is described in bug #22062.
+ </para>
+
+ <para>
+ The workaround to the problem is for the administrator to manually
+ grant the <literal>SHOW VIEW</literal> privilege to users who are
+ granted <literal>CREATE VIEW</literal>, since MySQL doesn't grant
+ it implicitly when views are created.
+ </para>
+
</section>
<section id="xa-restrictions">
Modified: trunk/refman-5.1/client-utility-programs.xml
===================================================================
--- trunk/refman-5.1/client-utility-programs.xml 2006-09-12 01:46:47 UTC (rev 3329)
+++ trunk/refman-5.1/client-utility-programs.xml 2006-09-12 10:46:33 UTC (rev 3330)
Changed blocks: 1, Lines Added: 20, Lines Deleted: 0; 1139 bytes
@@ -11358,6 +11358,26 @@
<xref linkend="backup"/>, and
<xref linkend="backup-strategy-example"/>.
</para>
+
+ <indexterm>
+ <primary>mysqldump</primary>
+ <secondary>views</secondary>
+ </indexterm>
+ <indexterm>
+ <primary>mysqldump</primary>
+ <secondary>problems</secondary>
+ </indexterm>
+ <indexterm>
+ <primary>mysqldump</primary>
+ <secondary>workarounds</secondary>
+ </indexterm>
+ <para>
+ If you encounter problems backing up views, please read the
+ section that covers restrictions on views which describes
+ a workaround for backing up views when this fails due to
+ insufficient privileges. See
+ <xref linkend="view-restrictions"/>.
+ </para>
</refsection>
Modified: trunk/refman-5.1/restrictions.xml
===================================================================
--- trunk/refman-5.1/restrictions.xml 2006-09-12 01:46:47 UTC (rev 3329)
+++ trunk/refman-5.1/restrictions.xml 2006-09-12 10:46:33 UTC (rev 3330)
Changed blocks: 1, Lines Added: 48, Lines Deleted: 0; 1932 bytes
@@ -927,6 +927,54 @@
</listitem>
</itemizedlist>
+
+ <indexterm>
+ <primary>mysqldump</primary>
+ <secondary>views</secondary>
+ </indexterm>
+ <indexterm>
+ <primary>mysqldump</primary>
+ <secondary>problems</secondary>
+ </indexterm>
+ <indexterm>
+ <primary>mysqldump</primary>
+ <secondary>workarounds</secondary>
+ </indexterm>
+ <indexterm>
+ <primary>Views</primary>
+ <secondary>limitations</secondary>
+ </indexterm>
+ <indexterm>
+ <primary>Views</primary>
+ <secondary>problems</secondary>
+ </indexterm>
+ <indexterm>
+ <primary>Views</primary>
+ <secondary>privileges</secondary>
+ </indexterm>
+
+ <para>
+ There exists a shortcoming with the current implementation of
+ views. If a user is granted the basic privileges necessary to
+ create a view (the <literal>CREATE VIEW</literal> and
+ <literal>SELECT</literal> privileges), that user will be unable
+ to call <literal>SHOW CREATE VIEW</literal> on that object unless
+ the user is also granted the <literal>SHOW VIEW</literal>
+ privilege.
+ </para>
+
+ <para>
+ That shortcoming can lead to problems backing up a database with
+ <command>mysqldump</command>, which may fail due to insufficient
+ privileges. This problem is described in bug #22062.
+ </para>
+
+ <para>
+ The workaround to the problem is for the administrator to manually
+ grant the <literal>SHOW VIEW</literal> privilege to users who are
+ granted <literal>CREATE VIEW</literal>, since MySQL doesn't grant
+ it implicitly when views are created.
+ </para>
</section>
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r3330 - in trunk: refman-5.0 refman-5.1 | stefan | 12 Sep |
