Archives of the TeradataForum
Message Posted: Tue, 03 Feb 2015 @ 23:31:48 GMT
| 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.
Dieter
| 
