Undo-Import Rights - System Emulation Tool

Teradata System Emulation Tool User Guide

Product
System Emulation Tool
Release Number
15.10
Language
English (United States)
Last Update
2018-10-07
dita:id
B035-2492
lifecycle
previous
Product Category
Teradata Tools and Utilities

Undo‑Import Rights

The Undo-Import Rights table below lists the privileges required to restore the default test system environment (also known as undo‑import or cleanup operations).

 

Table 3: Undo‑Import Rights 

Undo‑Import Information

Required Rights

Cost parameters

DELETE on SystemFE.Opt_Cost_Table and SystemFE.Opt_DBSCtl_Table or on SystemFE.

Execution plans

DELETE on the QCD tables or on the QCD.

EXECUTE on QCD macros.

Object definitions

Sufficient DROP rights on the parent database or DELETE on the database object.

RAS

DELETE on SystemFE.Opt_RAS_Table or on the SystemFE database.

Statistics

All rights required to execute the DROP STATISTICS statement for the table or join index referenced.

Demographics

DELETE on the data demographics table and corresponding views of the table.

EXECUTE on demographics macros and QCD macros.

QCD data

DELETE on QCD tables and views.

EXECUTE on QCD macros.

Workloads

DELETE on QCD tables and views.

EXECUTE on QCD macros.

Cost profiles

EXECUTE on the DBC.DeleteCostProfile macro.