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 |