16.20 - user_name ACCOUNT = ‘account_string’ - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Syntax and Examples

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-24
dita:mapPath
wkf1512081455740.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval

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’.

Example: Specify an account explicitly to discontinue request logging

If request logging is active on a specific account, you must specify that account explicitly to discontinue request logging.

This request removes the rule for user_1 logged on through the order entry account from the rule cache and DBC.DBQLRulesTbl and ends all query logging based on the rule.

     END QUERY LOGGING ON user_1 ACCOUNT = ('order_entry');