Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

Message Posted: Mon, 02 Jun 2008 @ 13:38:24 GMT


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


Subj:   Re: Duplicates in DBC.AccessRights after upgrading to V2R6.2
 
From:   Lubomir Ilanovsky

Hello,

  One note. You query does not take into account the ALLNESSFLAG or WITHGRANT columns. It is quite possible to have two rights assigned one with ALLNESS one without, and one will grant access while the other does not.  


In our case all values in duplicated rows are the same, except for the timestamp column.


  Have you opened an incident with Teradata for this? Yes, we have.  


During this weekend Teradata finally cleaned them up. Unfortunately we still do not know the cause and we have no recommendations to prevent such situation during the upgrade of our production system. I'll try to find out more, but I am not sure that even Teradata knows the answers right now.


Best Regards

Lubomir



     
  <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