16.20 - ON - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Syntax and Examples

Teradata Database
Teradata Vantage NewSQL Engine
Release Number
March 2019
English (United States)
Last Update

Keyword that precedes scope of logging for users, accounts, databases, or applications.

Logging for all users. The system logs each request performed for every user on the system. If you specify the USECOUNT option, logging is performed for all databases.
Name of one or more users for whom SQL request information is to be logged. The maximum number of individual user names you can specify in a single REPLACE QUERY LOGGING request is 100.
The more users you specify, the greater the impact on system performance.
If you specify a user_name with USECOUNT, the use count information for objects in the user database is logged, regardless of the user accessing the objects. If users access objects in another database, use count information is not logged unless the USECOUNT option is also specified for the containing database.
Name of one or more databases for which object use count data is to be logged.
ACCOUNT = ‘account_string
Set of user accounts for which SQL request information is to be logged for the specified user_name.
APPLNAME = ‘application_name
Logging is enabled or disabled for any user who logs on under the specified application name set.
Application names are the names Teradata Database passes in the UtilityName query band.