Bug #26196 automatic_sp_privileges variable not documented

• Submitted: 8 Feb 2007 21:25
• Modified: 21 Feb 2007 19:56
• Reporter: [ name withheld ]
• Status: Closed
• Category: MySQL Server: Documentation
• Severity: S3 (Non-critical)
• Version: 5.0.22-Debian_0ubuntu6.06.2
• Assigned to: Paul DuBois
• CPU Architecture: Any

[8 Feb 2007 21:25] [ name withheld ]

Description:
automatic_sp_privileges does not appear in http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html

root@host:/var/lib/mysql# mysqladmin variables | grep autom
| automatic_sp_privileges         | ON                                     |

How to repeat:
go to http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html and search for automatic_sp_privileges

[8 Feb 2007 22:43] Sveta Smirnova

Thank you for the report.

Verified as described. 

To find this variable, see  http://dev.mysql.com/doc/refman/5.0/en/mysqld-option-tables.html

[21 Feb 2007 19:56] Paul DuBois

Thank you for your bug report. This issue has been addressed in the documentation. The updated documentation will appear on our website shortly, and will be included in the next release of the relevant products.

Added to manual:

When this variable has a value of 1 (the default), the server 
automatically grants the EXECUTE and ALTER ROUTINE privileges to the
creator of a stored routine, if the user cannot already execute and
alter or drop the routine. (The ALTER ROUTINE privileges is required
to drop the routine.) The server also automatically drops those
privileges when the creator drops the routine. If
automatic_sp_privileges is 0, the server does not automatically add
and drop these privileges. This variable was added in MySQL 5.0.3.