Locks - Analytics Database - Teradata Vantage

SQL Data Definition Language Detailed Topics

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-07-11
dita:mapPath
vuk1628111288877.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
B035-1184
lifecycle
latest
Product Category
Teradata Vantage™

When a DROP USER statement is processed, the system places an EXCLUSIVE lock on the user being dropped.

Among the dictionary locks required for dropping the user, WRITE locks for deleting privileges from the partitioned DBC.AccessRights table are placed as follows:

  • An all-AMP WRITE lock is placed on the partition range assigned to objects in the dropped user/database. Although DROP USER can only be executed after all objects in the user have been dropped, a final delete is done to clean up any leftover privileges on the user's dropped objects.
  • For DROP USER only, an optional single-AMP WRITE lock is placed on the user's RowHash in all partitions if the user has been granted explicit privileges on objects in other users or databases that need to be deleted.