Archives of the TeradataForum
Message Posted: Thu, 05 Jun 2003 @ 16:35:14 GMT
| Subj: || || Re: Cleaning up DBC tables |
| From: || || McBride, Michael |
That is incorrect, we insert, update and delete from a view all the time. As long as the view is a base view (accessing one table only),
you can have the same permissions on it as you would have on the base table. We load all our DW tables through base views maintained in a
separate database. This alleviates the problem of granting general access to base tables.