To update rows and columns of a particular table, you must have DBA privileges or UPDATE privileges on all the specified columns of the target table, and SELECT privilege on all the other tables referred to in the statement.

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.