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

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0d
                  0d
                  Logged:
                  Time Spent - 8d 5h 20m
                  8d 5h 20m

                  Git Integration

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