Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 30 Aug 2000 @ 07:44:57 GMT

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

Subj:   Re: DBC.ACCESSRIGHTS error
From:   David Wellman


I doubt that adding new users will sort the index out. Adding rows to a table normally just adds entries to the index rather than rebuilding it.

To answer some other points raised in this thread;

- you may need to bypass accessrights in order to ins or delete (I think by default DBC doesn't have this privilege, but yours wouldn't be the first system I've seen where this has been added)

- from what I remember of the original Checktable error, your problem is that there are too many index entries (rather than say base rows without index entries). In this case you may well get away with no problems during normal processing - it all depends on whether those extra index entries are for tvm's which actually exist or not.

- dbc.accessrights can be skewed (well, usually 'lumpy' rather than skewed) but I doubt whether it's a major issue.

Good luck,


  <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