Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 01 Apr 2004 @ 13:28:12 GMT


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


Subj:   Re: User groups & methods of access
 
From:   Jose Lora

We have a single database containing views for each table in other databases. The database with views is used to allow users access during loading periods (ACCESS locking) and to help during changes on the underlying tables.

We handle user/group security levels in our BI tool (MicroStrategy) which allow us to create objects called Security Filters. This filters are added to the where conditions of the reports automatically, restricting the rows a user/group can see. Of course, this approach will not work if your users can use a different query tool and bypass the BI tool security mechanisms.


Jose Lora
Senior Systems Engineer



     
  <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