List:Commits« Previous MessageNext Message »
From:stefan Date:September 12 2006 10:46am
Subject:svn commit - mysqldoc@docsrva: r3330 - in trunk: refman-5.0 refman-5.1
View as plain text  
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.1stefan12 Sep