5780 Cannot DROP a user or database that has DBQL enabled

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;