Undo-Import Rights - System Emulation Tool

Teradata System Emulation Tool User Guide

Product
System Emulation Tool
Release Number
16.20
Published
October 2018
Language
English (United States)
Last Update
2018-10-12
dita:mapPath
gnf1527114222337.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2492
lifecycle
previous
Product Category
Teradata Tools and Utilities

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

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.
MH Maps DELETE on SystemFE.Opt_Map_Table and SystemFE.Opt_MapRel_Table or on the SystemFE Database