Title: WordPress database error DROP command denied to user
Last modified: October 3, 2018

---

# WordPress database error DROP command denied to user

 *  Resolved [cwolff](https://wordpress.org/support/users/cwolff/)
 * (@cwolff)
 * [7 years, 8 months ago](https://wordpress.org/support/topic/wordpress-database-error-drop-command-denied-to-user-2/)
 * Hi, getting many of these errors in the logs when a new Scan is initiated:
 * [03-Oct-2018 18:28:58 UTC] WordPress database error DROP command denied to user‘
   jis-cms’@’170.190.30.31’ for table ‘wp_wfhoover’ for query truncate table wp_wfHoover
   made by do_action(‘wp_ajax_wordfence_killScan’), WP_Hook->do_action, WP_Hook-
   >apply_filters, wordfence::ajaxReceiver, wordfence::ajax_killScan_callback, wfUtils::
   clearScanLock, wfDB->truncate, wfDB->queryWrite
 * The user in question does have DROP.
 * Thanks for any help offered.

Viewing 3 replies - 1 through 3 (of 3 total)

 *  [wfasa](https://wordpress.org/support/users/wfasa/)
 * (@wfasa)
 * [7 years, 8 months ago](https://wordpress.org/support/topic/wordpress-database-error-drop-command-denied-to-user-2/#post-10759651)
 * Hi [@cwolff](https://wordpress.org/support/users/cwolff/),
    It should not possible
   for this specific error message to occur if the user is allowed to DROP. I would
   recommend you check to make sure you don’t have duplicate tables and that you
   are connecting to the right database.
 * This query runs after the scan and cleans up scan data. Until you’ve figured 
   it out you may need to truncate the wfhoover table manually to prevent it from
   getting very big.
 *  [wfdave](https://wordpress.org/support/users/wfdave/)
 * (@wfdave)
 * [7 years, 7 months ago](https://wordpress.org/support/topic/wordpress-database-error-drop-command-denied-to-user-2/#post-10878243)
 * Hi [@cwolff](https://wordpress.org/support/users/cwolff/),
 * We haven’t heard back from you in a while. I’ve gone ahead and marked this thread
   as resolved. Please feel free to open another thread if you’re still having issues
   with Wordfence.
 * Thanks!
 *  Thread Starter [cwolff](https://wordpress.org/support/users/cwolff/)
 * (@cwolff)
 * [7 years, 7 months ago](https://wordpress.org/support/topic/wordpress-database-error-drop-command-denied-to-user-2/#post-10880322)
 * Thank you wfdave.
 * As suggested, giving the user “DROP” fixed the issue.

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘WordPress database error DROP command denied to user’ is closed to new
replies.

 * ![](https://ps.w.org/wordfence/assets/icon.svg?rev=2070865)
 * [Wordfence Security - Firewall, Malware Scan, and Login Security](https://wordpress.org/plugins/wordfence/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/wordfence/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/wordfence/)
 * [Active Topics](https://wordpress.org/support/plugin/wordfence/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wordfence/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wordfence/reviews/)

 * 3 replies
 * 3 participants
 * Last reply from: [cwolff](https://wordpress.org/support/users/cwolff/)
 * Last activity: [7 years, 7 months ago](https://wordpress.org/support/topic/wordpress-database-error-drop-command-denied-to-user-2/#post-10880322)
 * Status: resolved