Re: Permissions SHOW CREATE PROCEDURE

[Georgi Kodinov]

global SELECT is of course an option. But there are other options too. E.g. if you're the definer of the procedure:
mysql> show create function mysql.p1\G
*************************** 1. row ***************************
Function: p1
sql_mode: ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
Create Function: CREATE DEFINER=`foo`@`%` FUNCTION `p1`() RETURNS int(11)
DETERMINISTIC
return 12
character_set_client: cp850
collation_connection: cp850_general_ci
Database Collation: utf8mb4_0900_ai_ci
1 row in set (0.00 sec)

mysql> show grants;
+---------------------------------+
| Grants for foo@% |
+---------------------------------+
| GRANT USAGE ON *.* TO `foo`@`%` |
+---------------------------------+
1 row in set (0.00 sec)

But I do admit it's kind of limiting as it stands.

Georgi "Joro" Kodinov
MySQL SrvGen team lead
Plovdiv, Bulgaria