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

new db-level SHOW CREATE ROUTINE privilege

    XMLWordPrintable

Details

    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

        Activity

          People

            sanja Oleksandr Byelkin
            niljoshi Nilnandan Joshi
            Votes:
            1 Vote for this issue
            Watchers:
            6 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

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