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;