Search for a DBQL rule that logs all users for any account name using default logging. The system searches level 5 of the rules hierarchy and finds Rule 1.
SHOW QUERY LOGGING ON ALL;
The system searches level 5 of the rules hierarchy and finds a match (because there is no rule for user2 with any account, so Teradata Database defaults to the ALL user rule), and returns the DBC.DBQRules row for Rule 1 as follows.
Rule UserName "ALL" (From an ALL rule) Rule UserId 00000000 Account (Rule for any Account) DBQL RULE: Explain F Object F SQL F Step F XMLPlan F StatsUsage F UseCount F Param F Verbose F StatsDetails F UtilityInfo F Summary F Threshold F Text Size Limit 200