Export Rights - System Emulation Tool

Teradata® System Emulation Tool User Guide

Product
System Emulation Tool
Release Number
17.10
Published
June 2021
Language
English (United States)
Last Update
2021-07-01
dita:mapPath
hdo1608578450920.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2492
lifecycle
previous
Product Category
Teradata Tools and Utilities

Set privileges prior to performing export operations. When exporting by query, the right to execute the SHOW QUALIFIED SQL statement and configuration data (RAS, statistics, object definitions) is required if only those objects returned from this statement can be exported. The table below lists the privileges required to export each type of information.

Exported Information Required Rights
Cost parameters INSERT, SELECT, and DELETE on SystemFE.Opt_Cost_Table and SystemFE.Opt_DBSCtl_Table.
Execution plans For an existing plan:
  • SELECT on the QCD tables or on the QCD
  • EXECUTE on QCD macros

For a new plan, sufficient rights to execute the DUMP EXPLAIN statement for the given query.

For a new plan with demographics:
  • Sufficient rights to execute the INSERT EXPLAIN statement for the given query
  • EXECUTE on the QCD macros
New plans can be generated only from the Export By Query dialog box. See Export by Query.
Object definitions For join indexes, macros, tables, triggers, stored procedures, User Defined Functions (UDFs), NOS objects (foreign tables, authorizations and CSV schemas), and User-Defined Types (UDTs), sufficient rights to execute the corresponding SHOW/SHOW QUALIFIED statements for the database objects.

To export object definitions for view, SELECT on the view in order to perform the SHOW QUALIFIED statement.

To export by database, SELECT on DBC.Columns and DBC.Tables to export referenced UDTs.

Machine configuration MONRESOURCE privilege on V2R6.2 database.

EXECUTE FUNCTION access to SYSLIB.MonitorVirtualConfig and EXECUTE FUNCTION access to SYSLIB.MonitorPhysicalConfig on Teradata Database 12.0 and later database versions.

On a V2R6.2 database, this information is exported only when a CLIv2 connection is used. See Viewing Machine Configuration.
RAS SELECT on the tables selected for export.

INSERT, SELECT, and DELETE on SystemFE.Opt_RAS_Table.

Statistics All rights required to execute the HELP STATISTICS statement on the table or join index referenced.

SELECT on the DBC.IndexStats, DBC.ColumnStats, and DBC.MultiColumnStats views.

Demographics SELECT on the data demographics table and corresponding views of the table, and sufficient rights to execute the COLLECT DEMOGRAPHICS statement.

SELECT on QCD views.

EXECUTE on QCD macros.

This option is only available in export-by-database and export-by-query operations.
QCD data SELECT on QCD tables and views.

EXECUTE on QCD macros.

This option is only available in export-by-database operations.
Workloads SELECT on QCD tables and views.

EXECUTE on QCD macros.

This option is only available in export-by-workload operations.
Cost profiles SELECT on the DBC.CostProfiles_v and DBC.CostProfileValues_v views.
MH Maps SELECT on the tables selected for export.

INSERT, SELECT, and DELETE on SystemFE.Opt_Map_Table and SystemFE.Opt_MapRel_Table