Audit Log - Teradata Meta Data Services

Teradata Meta Data Services User Guide

Product
Teradata Meta Data Services
Release Number
15.00
Language
English (United States)
Last Update
2018-09-27
Product Category
Teradata Tools and Utilities

Audit Log

The Teradata MDS Audit Log is a table in the MDS repository that contains an audit trail of changes to the Teradata metadata. The MDS DDL Gateway Integrity Servers and the metaload utility write entries to the table. When audit logging is enable, each update to the DIM causes an entry to be inserted into the audit trail table.

You can view the contents of the Audit Trail when logged on as Administrator through MDS Repository Explorer, MetaManager, or by using SQL directly.

The Audit Trail can be accessed through the metaauditlog table or the mdsauditlog view.

Entries to the Audit Trail log can be viewed or deleted with Teradata MDS Repository Explorer.

Enabling and Disabling the Audit Log

1 In the Audit and Activity Logs area of the Repository Configuration screen, select the Audit Logging On check box (the default is Off).

To disable the audit logging, clear the Audit Logging On check box.

2 Click Apply Changes.

Viewing Audit Log Entries

1 Logon to Repository Explorer as an MDS Administrator (for example, metasu).

2 In the Navigation Pane, click Administration > Configuration Management > Audit Log.

The MDS Audit Log area appears.

3 In the Audit Log Search area, click Show All to view all entries, or specify a search filter, and then click Search.

The search results appear. For additional information, click .

Deleting Audit Log Entries

1 Logon to Repository Explorer as an MDS Administrator (for example, metasu).

2 In the Navigation Pane, click Administration > Configuration Management > Audit Log.

The Audit Log Report area appears.

3 In the Audit Log Search area, click Show All to view all entries, or specify a search filter, and then click Search.

4 Do one of the following:

  • To delete specific entries, select the entries by clicking the corresponding check boxes, and then click Delete Selected.
  • To delete all entries, click Delete All.
  • Note: Clicking Delete All will permanently delete all current entries in the Audit Log.

    For additional information, click .