Granting the DELETE Privilege on Tables and Views

Grant the privilege to delete all data in a specified table or view.

Prerequisites

Requires one of:

Task
To grant the DELETE privilege, enter:
GRANT DELETE
  ON table_name
  TO userID [,...]
Parent topic: Grant and Revoke Object-Level Privileges
Related tasks
Granting the Right to Administer an Object-Level Privilege
Related reference
GRANT Object-Level Privilege Statement