INSERT privilege for the owner of the view table
The
owner of the view table (see
CREATE VIEW statement) has the INSERT privilege, i.e. he or she can specify the view table as a table in which insertion is to be made in the INSERT statement if the following conditions are satisfied:- The view table is updateable (
updateable view table).
The owner of the view table has the INSERT privilege for all tables in the
FROM clause of the CREATE VIEW statement.
The
selected columns of the CREATE VIEW statement consist of table columns or column names, not
expressions with more than one column name.
The CREATE VIEW statement contains every mandatory column from all tables of the FROM clause as the selected column.