Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 06 Sep 2012 @ 19:30:07 GMT


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


Subj:   Re: Avoiding Multiple Views
 
From:   frank.c.martinez

We have created several views that check user against a table to see if they have access. This would mean at least one more join in the view, but it works well for what we're using it for (named value pairs). So in the source record, we differentiate the type of data, and then in a set of tables, we differentiate based on the user's available roles (so that we don't have to do anything fancy with our users for the other, normal views).


iv



     
  <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