Access Privileges - Teradata Tools and Utilities

Teradata® Archive/Recovery Utility Reference

Product
Teradata Tools and Utilities
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-06-05
dita:mapPath
fac1527114221922.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2412
Product Category
Teradata Tools and Utilities

The COPY statement requires these access privileges for database-level and table-level objects:

  • Create Macro (CM)
  • Create Table (CT)
  • Create View (CV)
  • Restore (RS)

The target database must also exist before making the copy.

To Copy a UIF object, the user named in the LOGON statement must have

  • The RESTORE privilege on the database targeted for the copy
You are not cannot grant the RESTORE privilege on the UIF object itself, but with the database-level RESTORE privilege, you can do a table-level copy of the individual UIF object.