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

MariaDB Audit Plugin audits SET GLOBAL

    Details

    • Type: Task
    • Status: Open (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Fix Version/s: None
    • Component/s: Plugin - Audit
    • Labels:
      None

      Description

      The 'server_audit_events' system variable currently supports the following event types as filters:

      • CONNECT
      • QUERY
      • TABLE
      • QUERY_DDL
      • QUERY_DML
      • QUERY_DCL

      I would like to request the following additional event type as a filter:

      • GLOBAL_VARIABLES

      If this event type is selected for audit logging, then whenever the SET GLOBAL command is executed, the audit plugin should log the following information to the audit log:

      • The name of the system variable that is being changed.
      • The old value of the system variable.
      • The new value of the system variable.

      Since the server_audit_% system variables can affect the audit logging configuration, it may be a good idea to make them special cases that are always logged, regardless of whether server_audit_events=GLOBAL_VARIABLES is set. See MDEV-17456 for more information about a previous problem related to that.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                holyfoot Alexey Botchkov
                Reporter:
                frericks Troy Frericks
              • Votes:
                0 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Created:
                  Updated: