16.10 - Tables - Teradata Database

Teradata Database Security Administration

prodname
Teradata Database
vrm_release
16.10
created_date
June 2017
category
Administration
Security
featnum
B035-1100-161K
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.