16.20 - Determining Whether an Account Was Specified for BEGIN QUERY LOGGING - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Detailed Topics

Teradata Database
Teradata Vantage NewSQL Engine
Release Number
March 2019
Content Type
Programming Reference
Publication ID
English (United States)

If you begin query logging on a specific account or account set, then you must perform one of the following actions to end query logging for that account or account set.

TO end query logging for … You must submit the following as the object of the ON clause in an END QUERY LOGGING request…
only a specified account or account set for a specific user the name of that account


the names of some or all of the accounts in the account set

This option deletes all rules for the specified account set for user_name.

all rules for all users ALL RULES

This option deletes all rules from DBC.DBQLRuleTbl, sets logging off for all active sessions, and clears all rules from the rules cache.

You can determine whether an account has been specified explicitly or not by submitting the following query against the DBQLRulesV view.

     SELECT *
     FROM DBQLRulesV;

This query reports all active rules, including whether accounts are specified for them or not.