Query Logging User Rules | BEGIN QUERY LOGGING | Teradata Vantage - Query Logging User Rules - Advanced SQL Engine - Teradata Database

Because you can log different information for different users, the system table DBC.DBQLRuleTbl maintains the various logging rules for each user. These rules are based on the logon account string for each logged user and are maintained in cache to promote their quick access.

This topic does not describe the rules hierarchy, but can be helpful for understanding default accounts and DBQL rules. See Hierarchy of Applying Database Query Logging Rules.

You must access the DBC.DBQLRulesV view. You cannot access either DBC.DBQLRuleTbl or DBC.DBQLRuleCountTbl directly.

Sessions are always associated with an account. At logon, the session is associated with the default account of the user who is logging on unless the logon string for that user specifies a different account assignment. See the logon pointer information in Teradata® Call-Level Interface Version 2 Reference for Workstation-Attached Systems, B035-2418.

Assume that user1 has a default account of abc, but is also assigned to account def and that you have submitted the following BEGIN QUERY LOGGING requests:

BEGIN QUERY LOGGING ON ALL ACCOUNT = 'ABC';

BEGIN QUERY LOGGING WITH OBJECTS ON user1 ACCOUNT = 'def';

In this scenario, if a user does not specify an account string when logging on, then the system applies the ALL rule instead of the user1 rule.

     BEGIN QUERY LOGGING WITH OBJECTS
       ON user1
       ACCOUNT =  'def ';

BEGIN QUERY LOGGING
  ON ALL
  ACCOUNT =  'abc ';