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

Add a "VIEW" mode to audit log plugin with similar behavior to "TABLE" plugin

    XMLWordPrintable

Details

    • New Feature
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • None
    • Plugin - Audit
    • None

    Description

      Example use case: Want to validate what tables and views are being used, but do NOT want full query log turned on.

      For table usage/accesses - the TABLE mode looks to cover this perfectly. However, if the tables were accessed via a view, you won't see the access to the original view.

      Option A) Add a 'VIEW' mode to the audit plugin that functions the same as table, but logs the view name that was accessed instead.

      Option B) Add a setting that controls the behavior of the current 'TABLE' mode for whether it additionally logs any view being accessed. (This should likely cascade as well - views of views of tables.)

      Option C) Just log the view accesses along with the table accesses in 'TABLE' mode.

      https://mariadb.com/docs/server/reference/plugins/mariadb-audit-plugin/mariadb-audit-plugin-log-settings

      Attachments

        Activity

          People

            Unassigned Unassigned
            nneul Nathan Neulinger
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.