The following SELECT statement retrieves the rules in effect for users:
SELECT * from DBC.DBQLRulesV;
Result:
UserName All Account ApplicationName TypeOfRule Logging enabled Explain F Object F SQL F Step T XMLPlan F StatsUsage F Verbose F DetailedStats F NoColumns F Summary F Threshold F ObjectUsage F Param F FeatureUsage T UtilityInfo F TextSize 200 Summary//Low ? Med ? High ? LockDelay 0 AlgMode ? TypeOfCriterion NO CRITERION DetailDiag ?
This rule was initiated as:
replace query logging with stepinfo, featureinfo on all;
The statement enables STEP and Feature Usage logging.