Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-28703

Unable to dump database with FUNCTION

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.4.24
    • None
    • Backup
    • 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.

      Attachments

        Activity

          People

            Unassigned Unassigned
            george.asenov George
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.