[MDEV-5270] SHOW CREATE PROCEDURE not showing procedure body if user no has GRANT SELECT ON mysql.proc Created: 2013-11-10 Updated: 2013-11-11 Resolved: 2013-11-11 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | None |
| Affects Version/s: | 5.5.33a |
| Fix Version/s: | None |
| Type: | Bug | Priority: | Major |
| Reporter: | Mikhail Gavrilov | Assignee: | Unassigned |
| Resolution: | Not a Bug | Votes: | 0 |
| Labels: | None | ||
| Environment: |
Linux |
||
| Description |
|
SHOW CREATE PROCEDURE not showing procedure body in field `Create Procedure` if user no has GRANT SELECT ON mysql.proc |
| Comments |
| Comment by Sergei Golubchik [ 2013-11-11 ] |
|
according to the manual, https://mariadb.com/kb/en/show-create-procedure/, to see the procedure body you must either be the owner of the routine or have the SELECT access to the mysql.proc table. |