Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 01 Apr 2004 @ 12:20:19 GMT


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


Subj:   Re: User groups & methods of access
 
From:   Tewksbury, Kevin

What we have is basically a xxxPdata database(division specific Production data), and then we would have a view database xxxPdataview, where we contain all of the views for Pdata. The users only get access to the xxxPdataview and only admin type id's get access to the base tables. We also carry an xxxPpayroll database, that contains secure information, with an xxxPsecureview database that contains all the views that are in xxxPdataview as well as all the views for secure information. Only certain users have access to the secureviews database. This appears to make it easier for us as we grant the select to users to the view databases only. Hope this helps. (We are at both V2R4.1.3 & V2R5.0.1)


KRT



     
  <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