11.6. Privileges Required for Update Statements

The privileges required for statements that modify tables are straightforward:

• INSERT, UPDATE, and DELETE require the INSERT, UPDATE, and DELETE privileges, respectively.

• REPLACE inserts records, possibly after deleting old records, so it requires the INSERT and DELETE privileges.

• TRUNCATE TABLE is like DELETE in that it deletes records, so it requires the DELETE privilege.