ON - Advanced SQL Engine - Teradata Database

SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Published
September 2020
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
wgr1555383704548.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1144
lifecycle
previous
Product Category
Teradata Vantage™

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

ALL
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.
user_name
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 BEGIN 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.
database_name
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 the system passes in the UtilityName query band. See "Reserved Load Utility Reserved Query Bands" in Teradata Vantage™ - SQL Data Definition Language Detailed Topics , B035-1184 .