Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 30 May 2008 @ 17:27:50 GMT

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

Subj:   Re: Duplicates in DBC.AccessRights after upgrading to V2R6.2
From:   Sanchez, Idrike

  For each two problem records in DBC.AccessRights the only difference is in the CreateTimestamp column. One of them contains NULL, the other contains timestamp.  

I find that we have the same issue on our production box after our 6.2 upgrade last year. Some are dupped based on CreateTimestamp others are dupped on CreateUID (or both).

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.

I don't think the dup rows are causing any harm, but it would be nice to have it cleaned up.

Have you opened an incident with Teradata for this?

Kiki Sanchez
Data Warehouse Group
Technology Division
Continental Airlines

  <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