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

Set privileges prior to performing import operations. The table below lists the privileges required to import each type of information.

Imported Information Required Rights
Cost parameters INSERT on SystemFE.Opt_Cost_Table and SystemFE.Opt_DBSCtl_Table.
Execution plans INSERT, SELECT, and UPDATE on QCD tables and views.
Object definitions CREATE on the user or database into which the information is imported. (Use to create database objects such as join indexes and stored procedures.)

CREATE PROCEDURE WITH GRANT OPTION for the database in which stored procedures are created.

CREATE EXTERNAL PROCEDURE WITH GRANT OPTION for the database in which external stored procedures are created.

CREATE FUNCTION WITH GRANT OPTION for the database in which User Defined Functions are to be created.

UDTTYPE on the SYSUDTLIB database, to create a UDT.

UDTUSAGE, to include a UDT with a CREATE TABLE statement.

RAS INSERT on SystemFE.Opt_RAS_Table.
Statistics All rights required to execute the COLLECT STATISTICS statement for the table or join index referenced.
Demographics INSERT, SELECT, and UPDATE on the data demographics table and corresponding table views.

EXECUTE for demographics macros.

QCD data INSERT, SELECT, and UPDATE on QCD tables.

SELECT on QCD views.

Workloads INSERT, SELECT, and UPDATE on QCD tables.

SELECT on QCD views.

Cost profiles EXECUTE on the DBC.CreateNewCostProfile and DBC.InsertConstantValue macros.
MH Maps INSERT on SystemFE.Opt_Map_Table and SystemFE.Opt_MapRel_Table