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

Audit plugin, Add functionality to filter per table (or object)

Details

    Description

      It would be powerful to filter auditing per objects(tables,views,etc), maybe with wildcards, so that only determined objects will be monitored.

      Currently the only non-class filter is the username filter(server_audit_incl-excl_users)

      Additionally, currently we can filter the audit log based on query type (INSERT, SELECT etc) and on users, we should also add the ability to filter based on the object by name or type.

      i.e. only audit mydb.mytable

      or only audit the object type VIEW.

      I would suggest:

      server_audit_object_type='CSV HERE'
      server_audit_object_name='CSV HERE'
      

      Attachments

        Issue Links

          Activity

            Transition Time In Source Status Execution Times
            Julien Fritsch made transition -
            Open Confirmed
            1032d 6h 24m 1
            Julien Fritsch made transition -
            Confirmed Open
            41d 16h 45m 1
            Ralf Gebhardt made transition -
            Open Closed
            1234d 4h 40m 1

            People

              Unassigned Unassigned
              claudio.nanni Claudio Nanni
              Votes:
              2 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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