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

Add the possibility to do an ALTER trigger DEFINER (and possibly other possibilities such as ENABLE/DISABLE)

        Details

        • Type: Task
        • Status: Open
        • Priority: Minor
        • Resolution: Unresolved
        • Fix Version/s: 10.2
        • Component/s: None

          Description

          For now, if you want to modify the definer of a trigger or any other of its parameters, you have to drop and recreate the trigger and manually lock/unlock the table to do this seamlessly.
          Another "possible solution" is to manually modify the .TRG file (which is definitely not recommanded).

          The ability to do an ALTER on a trigger to modify the definer, ENABLE/DISABLE the trigger, change its SQL mode and charset/collation would be interresting.

          There has been some chat about ALTER trigger ENABLE/DISABLE for quite some time on MySQL : http://dev.mysql.com/worklog/task/?id=2825

          ps: an ALTER VIEW DEFINER should also be implemented as the only alternative at the moment to do so is to modify manually the frm followed by a FLUSH TABLES which isnt a proper procedure.

            Gliffy Diagrams

              Attachments

                Issue Links

                links to

                Web Link TRIGGER definition should support SQL SECURITY = definer|invoker

                  Activity

                  Hide
                  Permalink
                  GeoffMontee Geoff Montee added a comment -

                  MDEV-6733 appears to be similar.

                  https://mariadb.atlassian.net/browse/MDEV-6733

                  Show
                  GeoffMontee Geoff Montee added a comment - MDEV-6733 appears to be similar. https://mariadb.atlassian.net/browse/MDEV-6733

                    People

                    • Assignee:
                      Unassigned
                      Reporter:
                      jb-boin Jean Weisbuch
                    • Votes:
                      0 Vote for this issue
                      Watchers:
                      4 Start watching this issue

                      Dates

                      • Created:
                        Updated: