on_items - Advanced SQL Engine - Teradata Database

SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Published
January 2021
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
ncd1596241368722.ditamap
dita:ditavalPath
hoy1596145193032.ditaval
dita:id
B035-1144
lifecycle
previous
Product Category
Teradata Vantage™

Specify scope of logging for users, accounts, databases, or applications:

Item Description
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 Teradata Vantage™ - SQL Data Definition Language Detailed Topics , B035-1184 .