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

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

        Details

        • Type: Bug
        • Status: Closed
        • Priority: Major
        • Resolution: Not a Bug
        • Affects Version/s: 10.1.2
        • Fix Version/s: N/A
        • Component/s: Documentation
        • Labels:
          None
        • Environment:
          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.

            Gliffy Diagrams

              Attachments

                Activity

                Ascending order - Click to sort in descending order
                Hide
                Permalink
                elenst Elena Stepanova added a comment -

                Hi,

                MariaDB has never supported this syntax (and neither has MySQL). It's a 3rd-party manual, it's wrong.

                For the variant ''@'localhost', it is supported but it has somewhat different semantics. It's not a wildcard for any user; it's an anonymous user. Users which have actual named accounts in your system won't match it.

                Show
                elenst Elena Stepanova added a comment - Hi, MariaDB has never supported this syntax (and neither has MySQL). It's a 3rd-party manual, it's wrong. For the variant ''@'localhost' , it is supported but it has somewhat different semantics. It's not a wildcard for any user; it's an anonymous user. Users which have actual named accounts in your system won't match it.
                Hide
                Permalink
                philip_38 Philip orleans added a comment -

                Can you point to the manual where I can see described how to gran execute
                rights to anonymous users?
                Federico

                On Wed, Feb 25, 2015 at 9:32 AM, Elena Stepanova (JIRA) <

                Show
                philip_38 Philip orleans added a comment - Can you point to the manual where I can see described how to gran execute rights to anonymous users? Federico On Wed, Feb 25, 2015 at 9:32 AM, Elena Stepanova (JIRA) <
                Hide
                Permalink
                elenst Elena Stepanova added a comment -

                http://dev.mysql.com/doc/refman/5.5/en/grant.html
                Search for 'anonymous'.

                Show
                elenst Elena Stepanova added a comment - http://dev.mysql.com/doc/refman/5.5/en/grant.html Search for 'anonymous'.

                  People

                  • Assignee:
                    Unassigned
                    Reporter:
                    philip_38 Philip orleans
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    2 Start watching this issue

                    Dates

                    • Created:
                      Updated:
                      Resolved: