Details
-
Task
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
Description
please, add a new db-level privilege SHOW CREATE ROUTINE so that the user with ALL PRIVILEGES on db level would be able to see all routines in that db
Update after discussing with Serg:
EXECUTE_ACL CREATE_PROC_ACL ALTER_PROC_ACL allow to get info about the routine, but SHOW_CREATE_ROUTINE_ACL should give the text.
This privilege related to PROCEDURE or FUNCTION or PACKAGE.
The effect of this MDEV is that one can give a user the 'show create routine' privilege, which allows the user to see the procedure text:
Example:
grant show create routine on *.* to user@localhost; |
show procedure code test_db.sp; |
Attachments
Issue Links
- causes
-
MDEV-33554 Upgrade from 11.2 to 11.3 changes root's privileges restricting GRANT ALL
-
- Closed
-
Activity
commit 44e692d0dbc69e2658e6e0e017d750fc62c0e8b8 (HEAD -> bb-11.3-MDEV-29167, origin/bb-11.3-MDEV-29167)
|
Author: Oleksandr Byelkin <sanja@mariadb.com>
|
Date: Mon Sep 4 13:04:06 2023 +0200
|
|
|
MDEV-29167 new db-level SHOW CREATE ROUTINE privilege
|
commit 5c487eb813b50f4d7de55acb8229b192ce396e8b (HEAD -> bb-11.3-MDEV-29167)
|
Author: Oleksandr Byelkin <sanja@mariadb.com>
|
Date: Wed Sep 6 09:54:42 2023 +0200
|
|
|
Convert priveleges string representation definition to non-error-pron STRING_WITH_LEN
|
|
|
commit 1b986fc4a078a4da166a54161fc51605b5e2d52e
|
Author: Oleksandr Byelkin <sanja@mariadb.com>
|
Date: Mon Sep 4 13:04:06 2023 +0200
|
|
|
MDEV-29167 new db-level SHOW CREATE ROUTINE privilege
|
commit ecc135603805a36688b5ec55fe04fa2feee8e565 (HEAD -> bb-11.3-MDEV-29167, origin/bb-11.3-MDEV-29167)
|
Author: Oleksandr Byelkin <sanja@mariadb.com>
|
Date: Mon Sep 4 13:04:06 2023 +0200
|
|
|
MDEV-29167 new db-level SHOW CREATE ROUTINE privilege
|
ROUTINES == PROCEDURE or FUNCTION or PACKAGE ?
I think TRIGGER is not routine in this sens but part of the table, right?