Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 15 Jan 2010 @ 12:50:32 GMT


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


Subj:   Merging user/rights from two machine onto one
 
From:   anne.k.kearney

Hi all,

We have a prod system and our sister org has a system of their own. We want to merge their environment (data and users) with the contents of our system. Data isn't the problem, but consolidating users and accessrights has presented a challenge. Has anyone done this, what worked and what challenges did you have. Any hiccups?

We need to grant at a table level not a database level. We dont use roles (as yet its a down the line thing) so the accessrights table is quiet big.

I've thought of spliting the table based on the col grantauthority and from there breaking out the accessrights and appending the sql but that seems very long winded. If this was your task, how would you do it?

I'd appreicate any info or assitance

thanks

anne



     
  <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