Archives of the TeradataForum

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

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

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>>