Author: paul
Date: 2007-02-21 21:05:59 +0100 (Wed, 21 Feb 2007)
New Revision: 5019
Log:
r20325@polar: paul | 2007-02-21 14:02:47 -0600
Document automatic_sp_privileges system variable. (Bug#26196)
Modified:
trunk/dynamic-docs/mysqld-optvar/options.xml
trunk/mysqld-optvars/options.xml
trunk/refman-5.0/database-administration.xml
trunk/refman-5.0/stored-procedures.xml
trunk/refman-5.1/database-administration.xml
trunk/refman-5.1/stored-procedures.xml
Property changes on: trunk
___________________________________________________________________
Name: svk:merge
- 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:20314
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:16605
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:14593
+ 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:20325
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:16605
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:14593
Modified: trunk/dynamic-docs/mysqld-optvar/options.xml
===================================================================
--- trunk/dynamic-docs/mysqld-optvar/options.xml 2007-02-21 19:11:10 UTC (rev 5018)
+++ trunk/dynamic-docs/mysqld-optvar/options.xml 2007-02-21 20:05:59 UTC (rev 5019)
Changed blocks: 1, Lines Added: 2, Lines Deleted: 1; 806 bytes
@@ -3387,13 +3387,14 @@
<optype class="cmdline" format="--automatic-sp-privileges"
setvar="automatic-sp-privileges"/>
<optype class="mycnf"/>
- <vartype class="server" isdynamic="yes"/>
+ <vartype class="server" isdynamic="yes" scope="global"/>
</types>
<values vartype="boolean" platform="all">
<value default="TRUE"/>
</values>
<versions>
<manual version="5.0"/>
+ <introduced version="5.0.3"/>
<manual version="5.1"/>
</versions>
</mysqloption>
Modified: trunk/mysqld-optvars/options.xml
===================================================================
--- trunk/mysqld-optvars/options.xml 2007-02-21 19:11:10 UTC (rev 5018)
+++ trunk/mysqld-optvars/options.xml 2007-02-21 20:05:59 UTC (rev 5019)
Changed blocks: 1, Lines Added: 2, Lines Deleted: 1; 770 bytes
@@ -3122,13 +3122,14 @@
<optype class="cmdline" format="--automatic-sp-privileges"
setvar="automatic-sp-privileges"/>
<optype class="mycnf"/>
- <vartype class="server" isdynamic="yes"/>
+ <vartype class="server" isdynamic="yes" scope="global"/>
</types>
<values vartype="boolean" platform="all">
<value default="TRUE"/>
</values>
<versions>
<manual version="5.0"/>
+ <introduced version="5.0.3"/>
<manual version="5.1"/>
</versions>
</mysqloption>
Modified: trunk/refman-5.0/database-administration.xml
===================================================================
--- trunk/refman-5.0/database-administration.xml 2007-02-21 19:11:10 UTC (rev 5018)
+++ trunk/refman-5.0/database-administration.xml 2007-02-21 20:05:59 UTC (rev 5019)
Changed blocks: 2, Lines Added: 25, Lines Deleted: 0; 1930 bytes
@@ -3513,6 +3513,26 @@
</listitem>
<listitem>
+ <para id="optvar_automatic-sp-privileges">
+ <literal>automatic_sp_privileges</literal>
+ </para>
+
+ <para>
+ When this variable has a value of 1 (the default), the
+ server automatically grants the <literal>EXECUTE</literal>
+ and <literal>ALTER ROUTINE</literal> privileges to the
+ creator of a stored routine, if the user cannot already
+ execute and alter or drop the routine. (The <literal>ALTER
+ ROUTINE</literal> privileges is required to drop the
+ routine.) The server also automatically drops those
+ privileges when the creator drops the routine. If
+ <literal>automatic_sp_privileges</literal> is 0, the
+ server does not automatically add and drop these
+ privileges. This variable was added in MySQL 5.0.3.
+ </para>
+ </listitem>
+
+ <listitem>
<para id="optvar_back_log">
<literal>back_log</literal>
</para>
@@ -7839,6 +7859,11 @@
<entry><literal>SESSION</literal></entry>
</row>
<row>
+ <entry><literal>automatic_sp_privileges</literal></entry>
+ <entry>boolean</entry>
+ <entry><literal>GLOBAL</literal></entry>
+ </row>
+ <row>
<entry><literal>big_tables</literal></entry>
<entry>boolean</entry>
<entry><literal>SESSION</literal></entry>
Modified: trunk/refman-5.0/stored-procedures.xml
===================================================================
--- trunk/refman-5.0/stored-procedures.xml 2007-02-21 19:11:10 UTC (rev 5018)
+++ trunk/refman-5.0/stored-procedures.xml 2007-02-21 20:05:59 UTC (rev 5019)
Changed blocks: 3, Lines Added: 13, Lines Deleted: 2; 1648 bytes
@@ -154,7 +154,8 @@
<para>
The <literal>ALTER ROUTINE</literal> privilege is needed to
alter or drop stored routines. This privilege is granted
- automatically to the creator of a routine.
+ automatically to the creator of a routine if necessary, and
+ dropped when the routine creator drops the routine.
</para>
</listitem>
@@ -162,7 +163,8 @@
<para>
The <literal>EXECUTE</literal> privilege is required to
execute stored routines. However, this privilege is granted
- automatically to the creator of a routine. Also, the default
+ automatically to the creator of a routine if necessary (and
+ dropped when the creator drops the routine). Also, the default
<literal>SQL SECURITY</literal> characteristic for a routine
is <literal>DEFINER</literal>, which enables users who have
access to the database with which the routine is associated to
@@ -170,6 +172,15 @@
</para>
</listitem>
+ <listitem>
+ <para>
+ If the <literal>automatic_sp_privileges</literal> system
+ variable is 0, the <literal>EXECUTE</literal> and
+ <literal>ALTER ROUTINE</literal> privileges are not
+ automatically granted and dropped.
+ </para>
+ </listitem>
+
</itemizedlist>
</section>
Modified: trunk/refman-5.1/database-administration.xml
===================================================================
--- trunk/refman-5.1/database-administration.xml 2007-02-21 19:11:10 UTC (rev 5018)
+++ trunk/refman-5.1/database-administration.xml 2007-02-21 20:05:59 UTC (rev 5019)
Changed blocks: 2, Lines Added: 25, Lines Deleted: 0; 1890 bytes
@@ -3586,6 +3586,26 @@
</listitem>
<listitem>
+ <para id="optvar_automatic-sp-privileges">
+ <literal>automatic_sp_privileges</literal>
+ </para>
+
+ <para>
+ When this variable has a value of 1 (the default), the
+ server automatically grants the <literal>EXECUTE</literal>
+ and <literal>ALTER ROUTINE</literal> privileges to the
+ creator of a stored routine, if the user cannot already
+ execute and alter or drop the routine. (The <literal>ALTER
+ ROUTINE</literal> privileges is required to drop the
+ routine.) The server also automatically drops those
+ privileges when the creator drops the routine. If
+ <literal>automatic_sp_privileges</literal> is 0, the
+ server does not automatically add and drop these
+ privileges.
+ </para>
+ </listitem>
+
+ <listitem>
<para id="optvar_back_log">
<literal>back_log</literal>
</para>
@@ -8023,6 +8043,11 @@
<entry><literal>SESSION</literal></entry>
</row>
<row>
+ <entry><literal>automatic_sp_privileges</literal></entry>
+ <entry>boolean</entry>
+ <entry><literal>GLOBAL</literal></entry>
+ </row>
+ <row>
<entry><literal>big_tables</literal></entry>
<entry>boolean</entry>
<entry><literal>SESSION</literal></entry>
Modified: trunk/refman-5.1/stored-procedures.xml
===================================================================
--- trunk/refman-5.1/stored-procedures.xml 2007-02-21 19:11:10 UTC (rev 5018)
+++ trunk/refman-5.1/stored-procedures.xml 2007-02-21 20:05:59 UTC (rev 5019)
Changed blocks: 3, Lines Added: 13, Lines Deleted: 2; 1648 bytes
@@ -157,7 +157,8 @@
<para>
The <literal>ALTER ROUTINE</literal> privilege is needed to
alter or drop stored routines. This privilege is granted
- automatically to the creator of a routine.
+ automatically to the creator of a routine if necessary, and
+ dropped when the routine creator drops the routine.
</para>
</listitem>
@@ -165,7 +166,8 @@
<para>
The <literal>EXECUTE</literal> privilege is required to
execute stored routines. However, this privilege is granted
- automatically to the creator of a routine. Also, the default
+ automatically to the creator of a routine if necessary (and
+ dropped when the creator drops the routine). Also, the default
<literal>SQL SECURITY</literal> characteristic for a routine
is <literal>DEFINER</literal>, which enables users who have
access to the database with which the routine is associated to
@@ -173,6 +175,15 @@
</para>
</listitem>
+ <listitem>
+ <para>
+ If the <literal>automatic_sp_privileges</literal> system
+ variable is 0, the <literal>EXECUTE</literal> and
+ <literal>ALTER ROUTINE</literal> privileges are not
+ automatically granted and dropped.
+ </para>
+ </listitem>
+
</itemizedlist>
</section>
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r5019 - in trunk: . dynamic-docs/mysqld-optvar mysqld-optvars refman-5.0 refman-5.1 | paul | 21 Feb |
