Bug #115641 SQL Error [3619] [HY000]: Illegal privilege level specified for SHOW_ROUTINE

• Submitted: 18 Jul 2024 16:12
• Modified: 19 Jul 2024 5:09
• Reporter: Yoni Sade
• Status: Not a Bug
• Category: MySQL Server
• Severity: S3 (Non-critical)
• Version: 8.0.37
• OS: Any
• CPU Architecture: Any

[18 Jul 2024 16:12] Yoni Sade

Description:
Cannot grant a user the SHOW_ROUTINE privilege on specific routines.

"GRANT SHOW_ROUTINE on mydb.myproc to myuser"

Gives:

SQL Error [3619] [HY000]: Illegal privilege level specified for myproc

So as trying to grant the same privilege on a specific database:

"GRANT SHOW_ROUTINE on mydb.* to myuser"

Gives:

SQL Error [3619] [HY000]: Illegal privilege level specified for SHOW_ROUTINE

How to repeat:
1. Create user `myuser`.
2. Create a database called `mydb`.
3. Create a stored procedure in `mydb` called `myproc`.
4. Try to grant SHOW_ROUTINE on `mydb`.`myproc` (or `mydb`.*) to `myuser`.

[18 Jul 2024 17:50] MySQL Verification Team

Hi Mr. Sade,

Thank you for your bug report.

However, it is not a bug.

If you have read our Reference Manual, you would have found out that this privilege can be granted only on the global level. Hence, not on schema or object level.

Not a bug.

[19 Jul 2024 5:09] Yoni Sade

Then can you please convert it to a feature request?

[19 Jul 2024 9:48] MySQL Verification Team

Sorry Mr. Sade,

We can not make new features that contradict SQL Standard.