Granting the ALTER Privilege on Tables

Grant the privilege to alter the structure of a table. This privilege does not apply to views.

Prerequisites

Requires one of:

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

Task

To grant the ALTER privilege, enter:

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