Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>   <<First <Prev

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


  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


  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020