Is it not possible that..
...inside a View definition, we have a select statement that gets all the new SCHEMA names for a unique known table name..(This unique table, say...

Thanks Andy for your reply.
I will try to simply my question: Below are 5 different tables which user access. Now aim is to have a single view with all...

Thanks Andy for your reply.
The idea was to have user access to all the data from different tables through a single view and the view shows data dynamically even...