Archives of the TeradataForum

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

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

All,

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

     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?

Kevin R Tewksbury

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