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>
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r11913 - in trunk: . dynamic-docs/changelog refman-6.0 | paul.dubois | 29 Sep |
