What is necessary for your query on an existing view to execute successfully
The underlying tables must have data
You need SELECT privileges on the view
The underlying tables must be in the same schema
You need SELECT privileges only on the underlying tables