Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 28 May 2008 @ 23:10:07 GMT


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


Subj:   Roles and view databases
 
From:   Anantaraman, Kumaran

Roles has been a relatively new feature in Teradata. Before that, access rights were typically handled using databases.

I would like to hear from the community on how they have implemented security on access to data to the warehouse. Do you have a mixture of roles and databases? Do the roles and databases map to subject areas / domains or job function or both? Do you use nested roles? If you have databases, do you have same views (same DDL) in multiple databases? Are there any risks in fully relying on roles for security (and place all views in 1 single database)?

This question is targeted to Data Warehouse implementations (versus collection of data marts on a single Teradata platform, where security is often easily managed at each data mart level).


Thank you.



     
  <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