MySQL Forums
Forum List  »  Security

Re: Permissions SHOW CREATE PROCEDURE
Posted by: Georgi Kodinov
Date: October 08, 2019 05:35AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
1314
October 07, 2019 12:22PM
236
October 07, 2019 01:32PM
Re: Permissions SHOW CREATE PROCEDURE
229
October 08, 2019 05:35AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.