Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 10 Sep 2012 @ 09:56:33 GMT


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


Subj:   Re: Difference between 3523 and 5315
 
From:   A, Surya Kumar

Hi Dave,

Prior to TD14 the access right check had different order which parsing the request. Error messaage is different in terms of description of the field.

TD13:

      BTEQ -- Enter your DBC/SQL request or BTEQ command:
     insert test2.tab1 sel a,b,c from  test2.t1 ;
      *** Failure 5315 The user does not have SELECT access to test2.t1.a.
                     Statement# 1, Info =0
      *** Total elapsed time was 1 second.

TD14 :

      BTEQ -- Enter your DBC/SQL request or BTEQ command:
     insert test2.tab1 sel a,b,c from  test2.t1 ;

     insert test2.tab1 sel a,b,c from  test2.t1 ;
      *** Failure 3523 The user does not have INSERT access to test2.tab1.
                     Statement# 1, Info =0
      *** Total elapsed time was 1 second.


     
  <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: 23 Jun 2019