Using the WITH AUDIT Clause

Use the WITH AUDIT keywords to create a table that will be included in the set of tables that are audited at the row level if selective row-level is enabled.

When you create a table with the WITH AUDIT clause, row-level audit events in that table are recorded when selective row-level auditing is turned on. Applying the WITH AUDIT attribute to a table by itself does not enable selective row-level auditing. This type of auditing is enabled when the ADTROWS parameter of the adtcfg file is set to 1 or 2 by using the onaudit -R command.

You must have RESOURCE or DBA privileges to run the CREATE TABLE statement with the WITH AUDIT clause.

Copyright© 2019 HCL Technologies Limited