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.