Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Mon, 13 Jan 2003 @ 21:24:28 GMT

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

Subj:   Re: Data selection
From:   Ken Hansen


One of TData's strengths is the ability to treat VIEWS as if they are TABLES and there is only an impact on performance where the views join tables with different indices.I am used to seeing different user-groups given rights to access specific database(s) as this is easier to manage than specific tables.

Therefore, I recommend you create a database of VIEWS which you want the user(s) to access. An example of use might be where all analysts may identify staff, id, office etc but not their salaries and home details. The latter would only be available on VIEWS in a database accessible by staff in HR.

Ken Hansen
Ivy House Associates

  <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: 28 Jun 2020