Tables | Privileges Needed for Database Administration | Teradata Vantage - Tables - Analytics Database - Teradata Vantage

SQL Data Control Language

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
sgu1628111251052.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
dvv1472243528022
lifecycle
latest
Product Category
Teradata Vantageā„¢
To... the user must have the...
create a table (including error table) CREATE TABLE privilege on the database or user in which the table is created.
alter or drop a table DROP TABLE on the table or the database that contains the table.

Additional privileges are required for altering a table to add or change a PI, security constraint column, or UDT column.

drop or rename a table DROP TABLE on the table or on the database containing the table
archive a table DUMP privilege on the database or table or you must be the owner of the table.

If the table has security constraint columns, you must also have OVERRIDE DUMP privilege.

copy a table the following privileges:
  • CREATE MACRO
  • CREATE TABLE
  • CREATE VIEW
  • RESTORE
Copying of security constraint tables is not supported.
restore a table CREATE TABLE privilege on the table being restored, or be an owner of the table.

If the table has security constraint columns, you must also have OVERRIDE RESTORE privilege.