Import Rights - System Emulation Tool

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