Details
-
New Feature
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
None
-
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.