Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.4.24
-
None
-
None
-
Rocky Linux release 8.5
4.18.0-305.17.1.el8_4.x86_64 #1
Description
If we have a database with FUNCTION/STORED PROCEDURE there is no way to dump it except if we do it as root(user with full privileges) or the definer of the function/procedure.
And there is no way we can create a user that have full access (including functions and procedures) to a limited set of databases.
mysqldump: user has insufficient privileges to SHOW CREATE FUNCTION `Function_name`!
There should be an option to create like master user which have access to number of databases and have full access to them so it can delete, view, dump, edit etc.
Otherwise we are forced to do backups and maintenance on client databases with root user.