To select a specified column, you must have DBA privileges or SELECT permission on all the tables or views referred to in the query_expression.

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.