REPLACE QUERY LOGGING with STEPINFO DETAILDIAG=128 on user1;
Report Granular AMP and STEP DBQL Logging Data to a User
SHOW QUERY LOGGING on user1;
Result:
Rule UserName user1
Rule UserId 00005404
Rule ZoneId 00000000
Account (Rule for any Account)
DBQL RULE:
Explain F
Object F
SQL F
Step T
XMLPlan F
StatsUsage F
UseCount F
Param F
FeatureUsage T
Verbose F
StatsDetails F
UtilityInfo F
NoColumns F
Summary F
Threshold F
Text Size Limit 200
DETAILDIAG RULE:
AMPDataDiag T
ExtDBQLData F
SumThreshOverride F
Report Default Logging Settings to All System-Level Users
SHOW QUERY LOGGING on ALL;
Result:
Rule UserName "ALL" (From a System rule)
Rule UserId 00000000
Rule ZoneId 00000000
Account (Rule for any Account)
DBQL RULE: Active System User
Explain F F F
Object F F F
SQL T T F
Step F F F
XMLPlan F F F
StatsUsage F F F
UseCount F F F
Param F F F
FeatureUsage T T F
Verbose F F F
StatsDetails F F F
UtilityInfo T T F
NoColumns F F F
Summary F F F
Threshold F F F
Text Size Limit 200 200 0