REFERENCES Privilege - Teradata Vantage - Analytics Database

SQL Data Control Language

Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2025-03-29
dita:mapPath
sgu1628111251052.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
dvv1472243528022
lifecycle
latest
Product Category
Teradata Vantageā„¢

The REFERENCES privilege applies at table and column levels. This privilege is required on all columns referenced, implicitly or explicitly, in a FOREIGN KEY clause of a CREATE TABLE or ALTER TABLE statement. The system grants this privilege automatically, with grant authority, to the creator of a table. Owners acquire the privilege implicitly.

If you specify a column list (for example, (column_name_1, ..., column_name_n)) with the keywords INSERT, REFERENCES, SELECT, or UPDATE, and the specified grantee set already has the privilege specified at the table level with the indicated grant authority, the system accepts the statement but takes no action. This is because having INSERT, REFERENCES, SELECT, or UPDATE privileges at table level also enables that action against all of its columns.