15.10 - user_name ACCOUNT = ‘account_string’ - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

prodname
Teradata Database
vrm_release
15.10
created_date
December 2015
category
Programming Reference
featnum
B035-1144-151K

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');