Oninit Logo
The Down System Specialists
+1-913-674-0360
+44-2081-337529
Partnerships Contact
Finderr

-275 The Insert privilege is required for this operation.

The Insert access privilege on this table or column is not currently held by your account name, nor by the PUBLIC group, nor by your current role. The owner of the table or the DBA must grant the Insert privilege before you can insert a row into this table.

This error is also returned when you attempt to insert a row into a view that is not updatable. A view is not updatable unless all of the following conditions are true: 1. All of the columns in the view are from a single table. 2. No columns in the projection list are aggregate values. 3. No UNIQUE or DISTINCT keyword is in the SELECT projection list. 4. No GROUP BY clause nor UNION, INTERSECT, or MINUS operator is in the view definition. 5. The query selects no calculated values and no literal values.

If only the first condition is false, and you hold the Insert and Select access privileges on all of the columns in the view, then you can define on the view an INSTEAD OF trigger whose triggered action inserts values into the base tables of the view, and use the trigger to perform the update.