Skip to main content
Question

ISSUE WITH AUDITING

  • July 9, 2020
  • 1 reply
  • 3 views

Joseph
Forum|alt.badge.img
  • Participating Frequently

When we run the audit with schema granularity level, the license size of schema 'ASD' is 10 TB.
command:select AUDIT('ASD', 'schema');

However, when we run the audit on the schema with table granularity level, the sum of the sizes of tables is only 4TB command:select AUDIT('ASD', 'table');

Why is there such a difference, which one is correct?

1 reply

LenoyJ
Forum|alt.badge.img+1
  • Participating Frequently
  • July 9, 2020

Can you share your Vertica version and the query you are using to query the V_CATALOG.USER_AUDITS system table?
 
Reference:
https://www.vertica.com/docs/10.0.x/HTML/Content/Authoring/SQLReferenceManual/Functions/VerticaFunctions/LicenseManagement/AUDIT.htm#Querying
Also check out error‑tolerance & confidence‑level parameters for the audit() function in the same page.