15.00 - Export Rights - System Emulation Tool

Teradata System Emulation Tool User Guide

prodname
System Emulation Tool
vrm_release
15.00
category
User Guide
featnum
B035-2492-034K

Export Rights

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 Export Rights table below lists the privileges required to export each type of information.

 

Table 1: Export Rights 

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
  • Note: New plans can be generated only from the Export By Query dialog box. See “Export by Query,” on page 61.

    Object definitions

    For join indexes, macros, tables, triggers, stored procedures, User Defined Functions (UDFs), and User‑Defined Types (UDTs), sufficient rights to execute the corresponding SHOW statement 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 TD 12.0 and later database versions.

    Note: On a V2R6.2 database, this information is exported only when a CLIv2 connection is used. See “View Machine Configuration” on page 116.

    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.

    Note: 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.

    Note: This option is only available in export‑by‑database operations.

    Workloads

    SELECT on QCD tables and views.

    EXECUTE on QCD macros.

    Note: This option is only available in export‑by‑workload operations.

    Cost profiles

    SELECT on the DBC.CostProfiles_v and DBC.CostProfileValues_v views.