Tables | Privileges Needed for Database Administration | Teradata Vantage - 17.10 - Tables - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Advanced SQL Engine Security Administration

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Administration
Security
Publication ID
B035-1100-171K
Language
English (United States)
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.