Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 01 Apr 2004 @ 11:26:06 GMT


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


Subj:   User groups & methods of access
 
From:   Anomy Anom

<-- Anonymously Posted: Thursday, April 01, 2004 06:23 -->

Currently we have a number of usergroups and have a database containing views for each usergroup. The usergroup has select access on their complete views database. Initially we had a requirement to provide different views of the same table to these usergroups. This means that if a usergroup requires access to data we create a view for them in their own views database.

However as we implement more tables we are finding that most usergroups require the same view to the data. Therefore we are considering changing to only one views database and granting usergroups access to a set of views within this database. If usergroups require different access to the same table, different views are created.

Are there any thoughts on this approach or what other sites do to control user access ?

( We are at V2 R4.1 )



     
  <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