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

Server audit: DDL executed via a stored procedure is invisible for QUERY_DDL

        Details

        • Type: Bug
        • Status: Open
        • Priority: Major
        • Resolution: Unresolved
        • Affects Version/s: N/A
        • Fix Version/s: 10.0, 5.5
        • Component/s: Plugin - Audit
        • Labels:

          Description

          MariaDB [test]> set global server_audit_events='QUERY_DDL';
Query OK, 0 rows affected (0.00 sec)

MariaDB [test]> create procedure p1() create table tmp (i int);
Query OK, 0 rows affected (0.00 sec)

MariaDB [test]> call p1();
Query OK, 0 rows affected (0.21 sec)

          Only procedure creation is logged, but neither procedure call nor table creation appear in the log.

            Gliffy Diagrams

              Attachments

                Activity

                There are no comments yet on this issue.

                  People

                  • Assignee:
                    holyfoot Alexey Botchkov
                    Reporter:
                    elenst Elena Stepanova
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    1 Start watching this issue

                    Dates

                    • Created:
                      Updated: