Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 05 Jun 2003 @ 16:35:14 GMT


     
  <Prev Next>   <<First <Prev Next> Last>>  


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.

mem



     
  <Prev Next>   <<First <Prev Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023