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