You must own the table or have DELETE permission. If the DELETE statement contains a WHERE clause, SELECT and DELETE permissions are required; otherwise, DELETE permission alone is sufficient.