Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 03 Feb 2015 @ 21:58:51 GMT

  <Prev Next>  
Next> Last>>  

Subj:   Why need DROP TABLE on a table for a delete
From:   Tewksbury, Kevin


We have an interesting issue. We are doing the below:

     Locking table database_a.table_a for exclusive
     Delete from database_a.table_a
     (select col_a
        From database_b.tmp_table_a

We are getting error that user does not have drop table access to database_a.table_a. There is no error table associated with this table. Why are we getting this error?

Kevin R Tewksbury

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