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

SHOW CREATE PROCEDURE not showing procedure body if user no has GRANT SELECT ON mysql.proc

        Details

        • Type: Bug
        • Status: Closed
        • Priority: Major
        • Resolution: Not a Bug
        • Affects Version/s: 5.5.33a
        • Fix Version/s: None
        • Component/s: None
        • Labels:
          None
        • Environment:
          Linux

          Description

          SHOW CREATE PROCEDURE not showing procedure body in field `Create Procedure` if user no has GRANT SELECT ON mysql.proc

            Gliffy Diagrams

              Attachments

                Activity

                Hide
                Permalink
                serg Sergei Golubchik added a comment -

                according to the manual, https://mariadb.com/kb/en/show-create-procedure/, to see the procedure body you must either be the owner of the routine or have the SELECT access to the mysql.proc table.

                Show
                serg Sergei Golubchik added a comment - according to the manual, https://mariadb.com/kb/en/show-create-procedure/ , to see the procedure body you must either be the owner of the routine or have the SELECT access to the mysql.proc table.

                  People

                  • Assignee:
                    Unassigned
                    Reporter:
                    mikhail Mikhail Gavrilov
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    2 Start watching this issue

                    Dates

                    • Created:
                      Updated:
                      Resolved: