svn commit - mysqldoc@docsrva: r11913 - in trunk: . dynamic-docs/changelog refman-6.0

[paul.dubois]

Author: paul
Date: 2008-09-29 22:01:52 +0200 (Mon, 29 Sep 2008)
New Revision: 11913

Log:
 r34313@frost:  paul | 2008-09-29 15:00:00 -0500
 Document the CREATE TABLESPACE privilege. (Required for
 CREATE/ALTER/DROP TABLESPACE/LOGFILE GROUP.)
 (WL#4300)


Modified:
   trunk/dynamic-docs/changelog/mysqld-1.xml
   trunk/refman-6.0/dba-core.xml
   trunk/refman-6.0/sql-syntax-server-administration.xml

Property changes on: trunk
___________________________________________________________________
Name: svk:merge
   - 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:35828
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:34297
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:33355
   + 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:35828
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:34313
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:33355


Modified: trunk/dynamic-docs/changelog/mysqld-1.xml
===================================================================
--- trunk/dynamic-docs/changelog/mysqld-1.xml	2008-09-29 17:56:28 UTC (rev 11912)
+++ trunk/dynamic-docs/changelog/mysqld-1.xml	2008-09-29 20:01:52 UTC (rev 11913)
Changed blocks: 1, Lines Added: 24, Lines Deleted: 0; 832 bytes

@@ -27785,4 +27785,28 @@
 
   </logentry>
 
+  <logentry entrytype="feature">
+
+    <tags>
+      <manual type="tablespaces"/>
+      <manual type="logfile groups"/>
+    </tags>
+
+    <versions>
+      <version ver="6.0.7"/>
+    </versions>
+
+    <message>
+
+      <para>
+        The <literal>CREATE TABLESPACE</literal> privilege has been
+        introduced. This privilege exists at the global (superuser)
+        level and enables you to create, alter, and drop tablespaces and
+        logfile groups.
+      </para>
+
+    </message>
+
+  </logentry>
+
 </changelog>


Modified: trunk/refman-6.0/dba-core.xml
===================================================================
--- trunk/refman-6.0/dba-core.xml	2008-09-29 17:56:28 UTC (rev 11912)
+++ trunk/refman-6.0/dba-core.xml	2008-09-29 20:01:52 UTC (rev 11913)
Changed blocks: 5, Lines Added: 25, Lines Deleted: 0; 2170 bytes

@@ -16509,6 +16509,11 @@
               <entry/>
             </row>
             <row>
+              <entry/>
+             
<entry><literal>Create_tablespace_priv</literal></entry>
+              <entry/>
+            </row>
+            <row>
               <entry><emphasis role="bold">Security
columns</emphasis></entry>
               <entry><literal>ssl_type</literal></entry>
               <entry/>

@@ -16553,6 +16558,11 @@
       </informaltable>
 
       <para>
+        The <literal>Create_tablespace_priv</literal> column was added
+        in MySQL 6.0.7.
+      </para>
+
+      <para>
         During the second stage of access control, the server performs
         request verification to make sure that each client has
         sufficient privileges for each request that it issues. In

@@ -17103,6 +17113,11 @@
               <entry>tables</entry>
             </row>
             <row>
+              <entry><literal>CREATE TABLESPACE</literal></entry>
+             
<entry><literal>Create_tablespace_priv</literal></entry>
+              <entry>tables</entry>
+            </row>
+            <row>
               <entry><literal>CREATE VIEW</literal></entry>
               <entry><literal>Create_view_priv</literal></entry>
               <entry>views</entry>

@@ -17196,6 +17211,11 @@
       </para>
 
       <para>
+        The <literal>CREATE TABLESPACE</literal> privilege was added in
+        MySQL 6.0.7.
+      </para>
+
+      <para>
         To create or alter stored functions if binary logging is
         enabled, you may also need the <literal>SUPER</literal>
         privilege, as described in

@@ -17271,6 +17291,11 @@
       </para>
 
       <para>
+        The <literal>CREATE TABLESPACE</literal> privilege enables you
+        to create, alter, and drop tablespaces and logfile groups.
+      </para>
+
+      <para>
         The <literal>EVENT</literal> privilege enables you to set up
         events for the event scheduler.
       </para>


Modified: trunk/refman-6.0/sql-syntax-server-administration.xml
===================================================================
--- trunk/refman-6.0/sql-syntax-server-administration.xml	2008-09-29 17:56:28 UTC (rev
11912)
+++ trunk/refman-6.0/sql-syntax-server-administration.xml	2008-09-29 20:01:52 UTC (rev
11913)
Changed blocks: 4, Lines Added: 18, Lines Deleted: 4; 2552 bytes

@@ -258,7 +258,7 @@
         WITH SUBJECT OPTION MAX_QUERIES_PER_HOUR MAX_UPDATES_PER_HOUR
         MAX_CONNECTIONS_PER_HOUR MAX_USER_CONNECTIONS CLIENT EXECUTE
         FILE SSL X509 SECURITY USAGE SUPER NONE PROCESS PRIVILEGES
-        REFERENCES RELOAD REPLICATION SHUTDOWN
+        REFERENCES RELOAD REPLICATION SHUTDOWN TABLESPACE
       </remark>
 
       <remark role="help-syntax-begin"/>

@@ -540,6 +540,14 @@
               <entry>Enables use of <literal>CREATE TEMPORARY
TABLE</literal></entry>
             </row>
             <row>
+              <entry><literal>CREATE TABLESPACE</literal></entry>
+              <entry>Enables use of <literal>CREATE
TABLESPACE</literal>, <literal>ALTER
+                TABLESPACE</literal>, <literal>DROP
+                TABLESPACE</literal>, <literal>CREATE LOGFILE
+                GROUP</literal>, <literal>ALTER LOGFILE
GROUP</literal>,
+                and <literal>DROP LOGFILE GROUP</literal>.</entry>
+            </row>
+            <row>
               <entry><literal>CREATE USER</literal></entry>
               <entry>Enables use of <literal>CREATE USER</literal>,
<literal>DROP
                 USER</literal>, <literal>RENAME USER</literal>, and

@@ -652,6 +660,11 @@
       </informaltable>
 
       <para>
+        The <literal>CREATE TABLESPACE</literal> privilege was added in
+        MySQL 6.0.7.
+      </para>
+
+      <para>
         A trigger is associated with a table, so to create or drop a
         trigger, you must have the <literal>TRIGGER</literal> privilege
         for the table, not the trigger.

@@ -685,9 +698,10 @@
         <literal>RELOAD</literal>, <literal>REPLICATION
         CLIENT</literal>, <literal>REPLICATION SLAVE</literal>,
         <literal>SHOW DATABASES</literal>,
<literal>SHUTDOWN</literal>,
-        <literal>SUPER</literal>, and <literal>CREATE
USER</literal>
-        privileges are administrative privileges that can only be
-        granted globally (using <literal>ON *.*</literal> syntax).
+        <literal>SUPER</literal>, <literal>CREATE
TABLESPACE</literal>,
+        and <literal>CREATE USER</literal> privileges are administrative
+        privileges that can only be granted globally (using <literal>ON
+        *.*</literal> syntax).
       </para>
 
       <para>