Bug #28667 Privilege to allow TRUNCATE and deny DROP ?

• Submitted: 25 May 2007 8:35
• Reporter: Nicolae Namolovan
• Status: Open
• Category: MySQL Server: Security: Privileges
• Severity: S4 (Feature request)
• Version: 5.1.18
• OS: Any
• CPU Architecture: Any
• Triage: D5 (Feature request)

[25 May 2007 8:35] Nicolae Namolovan

Description:
"TRUNCATE TABLE requires the DROP privilege as of MySQL 5.1.16. (Before 5.1.16, it requires the DELETE privilege."

Giving DROP privilege is too much, I don't want user to drop the table.
Still I want a fast "delete all rows" function.

How to repeat:
mysql> TRUNCATE ..;
ERROR 1142 (42000): DROP command denied to user '..'@'localhost' for table '..'

[26 May 2007 8:32] Valeriy Kravchuk

Sounds like a feature request.