Work with the Access Log - Teradata Administrator

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.

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

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

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.