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

Grant execute on all users does not work as the manual says

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Not a Bug
    • 10.1.2
    • N/A
    • Documentation
    • None
    • fedora 20

    Description

      I have a stored procedure that I want all my users to be able to execute, without having to assign the privilege individually, since they are hundreds.
      So I found in the manual this statement
      GRANT EXECUTE ON PROCEDURE MariaDBProc TO '*'@'localhost';
      http://www.techonthenet.com/mariadb/grant_revoke.php
      In old mysql, they say to use
      GRANT EXECUTE ON PROCEDURE MariaDBProc TO ''@'localhost';
      I actually use
      GRANT EXECUTE ON PROCEDURE MariaDBProc TO '*'@'%';
      or
      GRANT EXECUTE ON PROCEDURE MariaDBProc TO ''@'';
      but neither statement makes my users to execute the stored procedure.

      Attachments

        Activity

          People

            Unassigned Unassigned
            philip_38 Philip orleans
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.