Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 06 Sep 2012 @ 18:09:31 GMT


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


Subj:   Avoiding Multiple Views
 
From:   Anomy Anom

< -- Anonymously Posted: Thursday, September 06, 2012 10:36 -- >

Hi,

We are receiving data from 30 different source system's and the data is stored in a single table. The users from each source system should only have access to their own data. We can achieve this by creating 30 views and having a filter condition.

Is there any other way of achieving this without having to create 30 different views? Can this be achieved by? creating only one view? If so how?

Any suggestions are welcome.


Thanks in advance.



     
  <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: 27 Dec 2016