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

          duplicates

          Task - A task that needs to be done. MDEV-18522 Audit log filter for objects

          • Major - Major loss of function.
          • Closed
          is blocked by

          Task - A task that needs to be done. MDEV-5983 Auditing plugin v2.0

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            claudio.nanni Claudio Nanni created issue -
            ccalender Chris Calender (Inactive) made changes -
            Field Original Value New Value
            Support case ID 20719 20719 26207
            ccalender Chris Calender (Inactive) made changes -
            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)
            		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:
            {code}
            server_audit_object_type='CSV HERE'
            server_audit_object_name='CSV HERE'
            {code}
            ralf.gebhardt Ralf Gebhardt made changes -
            julien.fritsch Julien Fritsch made changes -
            Status Open [ 1 ] Confirmed [ 10101 ]
            julien.fritsch Julien Fritsch made changes -
            Status Confirmed [ 10101 ] Open [ 1 ]
            julien.fritsch Julien Fritsch made changes -
            julien.fritsch Julien Fritsch made changes -
            Assignee Ralf Gebhardt [ ralf.gebhardt@mariadb.com ]
            ralf.gebhardt Ralf Gebhardt made changes -
            Assignee Ralf Gebhardt [ ralf.gebhardt@mariadb.com ]
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 75613 ] MariaDB v4 [ 130474 ]
            ralf.gebhardt Ralf Gebhardt added a comment -

            Done for MariaDB Enterprise Audit were we have a better way to define filters

            ralf.gebhardt Ralf Gebhardt added a comment - Done for MariaDB Enterprise Audit were we have a better way to define filters
            ralf.gebhardt Ralf Gebhardt made changes -
            Fix Version/s N/A [ 14700 ]
            Resolution Won't Do [ 10201 ]
            Status Open [ 1 ] Closed [ 6 ]

            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.