Bug #14261 | procedures don't show current user | ||
---|---|---|---|
Submitted: | 24 Oct 2005 15:07 | Modified: | 24 Oct 2005 15:49 |
Reporter: | hala t | Email Updates: | |
Status: | Not a Bug | Impact on me: | |
Category: | MySQL Server | Severity: | S2 (Serious) |
Version: | OS: | Windows (winxp) | |
Assigned to: | CPU Architecture: | Any |
[24 Oct 2005 15:07]
hala t
[24 Oct 2005 15:49]
Valeriy Kravchuk
Thank you for taking the time to write to us, but this is not a bug. Please double-check the documentation available at http://www.mysql.com/documentation/ and the instructions on how to report a bug at http://bugs.mysql.com/how-to-report.php Additional info: Please, read the manual (http://dev.mysql.com/doc/refman/5.0/en/create-procedure.html): "The SQL SECURITY characteristic can be used to specify whether the routine should be executed using the permissions of the user who creates the routine or the user who invokes it. The default value is DEFINER. This feature is new in SQL:2003. The creator or invoker must have permission to access the database with which the routine is associated." So, by default the procedure is axecuted as user who defined it, and shows his name as a current user. It is a correct and documented behaviour, not a bug.