17.05 - END QUERY LOGGING Syntax Elements - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Release Date
January 2021
Content Type
Programming Reference
Publication ID
B035-1144-175K
Language
English (United States)

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.