[MDEV-10040] Audit plugin, Add functionality to filter per table (or object) Created: 2016-05-07  Updated: 2022-09-01  Resolved: 2022-09-01

Status: Closed
Project: MariaDB Server
Component/s: Plugin - Audit
Fix Version/s: N/A

Type: Task Priority: Major
Reporter: Claudio Nanni Assignee: Unassigned
Resolution: Won't Do Votes: 2
Labels: None

Issue Links:
Blocks
is blocked by MDEV-5983 Auditing plugin v2.0 Closed
Duplicate
duplicates MDEV-18522 Audit log filter for objects Closed

 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'



 Comments   
Comment by Ralf Gebhardt [ 2022-09-01 ]

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

Generated at Thu Feb 08 07:39:13 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.