For your scenario, I would recommend to execute the query on the VQL shell for which the user has the appropriate column permission in Pass-Through credential mode.
For example :
`select <column 1>,<column2>,<column n> From <View_name>`
For detailed information, you can refer to section [Considerations When Configuring Data Sources with Pass-Through Credentials ](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/appendix/considerations_when_configuring_data_sources_with_pass-through_credentials/considerations_when_configuring_data_sources_with_pass-through_credentials) of the Virtual DataPort Administration Guide.
Hope this helps!