Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 03 Feb 2015 @ 23:31:48 GMT

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

Subj:   Re: Why need DROP TABLE on a table for a delete
From:   Dieter Noeth

Kevin Tewksbury wrote:

          > Locking table database_a.table_a for exclusive Delete from
          > database_a.table_a Where
          > (col_a)
          > In
          > (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?  

An exclusice lock can only be requested if the user has the DROP right on the table.

Similar if you try to LOCK WRITE without INSERT/UPDATE or DELETE rights.


  <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