Work with the Access Log - Teradata Administrator

Teradata Administrator User Guide

Product
Teradata Administrator
Release Number
15.00
Language
English (United States)
Last Update
2018-09-27
dita:id
B035-2502
lifecycle
previous
Product Category
Teradata Tools and Utilities

Work with the Access Log

With Teradata Administrator, start or stop access logging for specific tables, databases, or users. Also, review all the current Access Log rules that are defined on the database.

Use the following procedure for access logging.

To work with the access log

1 From the main window, click Tools>Access Logging.

2 Define the attributes and options as indicated in Table 32 on page 92.

3 Use the buttons on the dialog box as follows:

  • Begin Log - defines an access logging rule for the selected user(s), database, and object (optional).
  • End Log - revokes an existing access logging rule for the selected user(s), database, and object (optional).
  • If SQL is used for logging and the user ends logging with SQL, this simply removes the “with SQL” attribute. To remove the rule itself, clear the with SQL check box, and then issue an End Log command.

  • Display - displays a report of the existing access logging rules. To limit the scope of this report, select a specific database or user.
  • Clear - clears the fields in this dialog box.
  • 4 Click Close when finished.