Too bad.  I don't think I want to mess with system tables or views.  Thanks, Paul

The user is granted select on a small subset of views in one database.  The problem is that he can see all the other views (plus all tables) in Query Analyzer Object...

Thanks to all who contributed to this thread and especially Calvin. Your ideas helped me in a pinch to get out some needed reports in short order, saving me...

Thanks, that would work (with ' instead of "), but actually, with many hundreds of identically structured tables, I was hoping for a way to insert each source table name...

Is there a way, in this process, to add a column which inserts in each record the name of the table from which it came?

--Paul

quote:

---

If I recall correctly, you can use UNION ALL instead of UNION and it should increase your performance slightly.

-Aaron

---