Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 16 Aug 2005 @ 16:34:25 GMT


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


Subj:   Re: set role ALL
 
From:   Matthew Winter

Hi,

We have been using roles for quite a while, and with Business Objects.

There are several reason why you would want to make use of roles over the top of individual user access rights.

1. The biggest reason for using roles, is to reduce the number of records within the access rights table, which can add a significant overhead when the numbers increase.

2. Ease of maintenance. In general you will tend to have common groups of functional users, in your case 'Data Modeller' and the individual Cognos projects sounds like a perfect match to a role within Teradata.


Regards

Matthew Winter



     
  <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