To insert a row, you must have DBA privileges, ownership of the table, INSERT privilege on the table, or SELECT privilege on all the tables or views referred to in the query_expression, if it is specified.

A user mapped to a super-tenant can view data for all the tenants only if the user has the required permissions on the tables referenced in the statement.