END QUERY LOGGING Syntax Elements - 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™

account_specification

ALL
All logging rules are removed for the specified accounts from DBC.DBQLRulesTbl and the rules cache and logging based on those rules is discontinued.
user_name_1
Logging rules are removed for the specified user:account pair from DBC.DBQLRulesTbl and the rules cache. Logging based on those rules is discontinued. You can optionally specify multiple accounts on which to discontinue logging for the user.
If query logging is active for a specific user:account pair, you must specify that user:account pair to end query logging.
You cannot specify multiple user names if you specify ACCOUNT = ‘account_string’.
user_name_2
Logging rules are removed for the specified user name set from DBC.DBQLRulesTbl and the rules cache. Logging based on those rules is discontinued.
database_name
Logging rules are removed for the specified database name set from DBC.DBQLRulesTbl and the rules cache. Logging based on those rules is discontinued.

application_specification

application_name
Logging rules are removed for the specified application name set from DBC.DBQLRulesTbl and the rules cache. Logging based on those rules is discontinued.
Vantage reevaluates all active sessions to determine if any other rules apply.