Inserting Rows Through Views
Use caution when granting the privilege to insert data through a view because data
in fields not visible to the user might be inserted when a row is inserted through
a view.
The following rules apply to inserting rows through a view:
Both you and the immediate owner of the view must have the appropriate privileges.
The view must reference columns in only one table or view.
None of the columns in the view can be derived by using an expression to change values
in the underlying table.
Each column in the view must correspond one to one with a column in the underlying
table or view.
The view must include any column in the underlying table or view that is declared
as NOT NULL.
No two view columns can reference the same column in the underlying table.
If the request used to define a view contains a WHERE clause, and WITH CHECK OPTION,
all values inserted through that view must satisfy constraints specified in the WHERE
clause.
If a view includes a WHERE clause but does not include the WITH CHECK OPTION, then
data can be inserted that is not visible through that view.