There are several distinct permissions you may grant to user IDs concerning tables and views:
| Permission | Description |
|---|---|
| ALTER | Permission to alter the structure of a table or create a trigger on a table. |
| DELETE | Permission to delete rows from a table or view. |
| INSERT | Permission to insert rows into a table or view. |
| REFERENCES | Permission to create indexes on a table and to create foreign keys that reference a table. |
| SELECT | Permission to look at information in a table or view. |
| UPDATE | Permission to update rows in a table or view. This can also granted on a set of columns in a table or view. |
| ALL | All the above permissions. |