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

MySQL bug#11759114 - '51401: GRANT TREATS NONEXISTENT FUNCTIONS/PRIVILEGES DIFFERENTLY'

    XMLWordPrintable

    Details

    • Sprint:
      10.0.20

      Description

      revno: 2876.425.12
      committer: Dmitry Lenev <Dmitry.Lenev@oracle.com>
      branch nick: mysql-trunk-11759114
      timestamp: Fri 2011-04-22 16:59:10 +0400
      message:
        Fix for bug#11759114 - '51401: GRANT TREATS NONEXISTENT
        FUNCTIONS/PRIVILEGES DIFFERENTLY'.
       
        The problem was that attempt to grant EXECUTE or ALTER
        ROUTINE privilege on stored procedure which didn't exist
        succeed instead of returning an appropriate error like
        it happens in similar situation for stored functions or
        tables.
       
        The code which handles granting of privileges on individual
        routine calls sp_exist_routines() function to check if routine
        exists and assumes that the 3rd parameter of the latter
        specifies whether it should check for existence of stored
        procedure or function. In practice, this parameter had
        completely different meaning and, as result, this check was
        not done properly for stored procedures.
       
        This fix addresses this problem by bringing sp_exist_routines()
        signature and code in line with expectation of its caller.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              svoj Sergey Vojtovich
              Reporter:
              svoj Sergey Vojtovich
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: