Hya,

Responses.

1. User has select and use on the schema, have tried execute the other day but it made no difference.
2. We can`t do this as the database filtered by the view has to be controlled by us as it`s part of a multi-tenanted setup.
3. Tried this. Seems to work!
4. See above.

Thanks for the response!