Problem:
drop database ITAxCRMBI;
5780 Cannot DROP a user or database that has DBQL enabled.
Solution:
You cannot drop a user or database that has DBQL logging enabled. First disable logging for that user or database.
show query logging on ITAxCRMBI;
Request Text
Rule UserName ITAxCRMBI
Rule UserId 00001843
Rule ZoneId 00000000
Account (Rule for any Account)
DBQL RULE:
Explain F
Object F
SQL F
Step F
XMLPlan F
StatsUsage F
UseCount T
Param F
FeatureUsage F
Verbose F
StatsDetails F
UtilityInfo F
NoColumns F
Summary F
Threshold F
Text Size Limit 200
end query logging on ITAxCRMBI;
show query logging on ITAxCRMBI;
Request Text
Rule UserName ITAxCRMBI (From an ALL rule)
Rule UserId 00000000
Rule ZoneId 00000000
Account (Rule for any Account)
DBQL RULE:
Explain F
Object F
SQL T
Step F
XMLPlan F
StatsUsage T
UseCount F
Param F
FeatureUsage F
Verbose F
StatsDetails F
UtilityInfo F
NoColumns F
Summary F
Threshold F
Text Size Limit 300
drop database ITAxCRMBI;