Granting the INSERT Privilege on Tables and Views

Grant the privilege to insert data into a table or view.

Prerequisites

Requires one of:

You have been granted the MANAGE ANY OBJECT PRIVILEGE system privilege.
You have been granted the INSERT object privilege on the table with the WITH GRANT OPTION clause.
You own the table.

Task

To grant the INSERT privilege, enter:

GRANT INSERT
  ON table_name
  TO userID [,...]