The table below lists the privileges required to restore the default test system environment (also known as undo-import or cleanup operations).
Undo-Import Information | Required Rights |
---|---|
Cost parameters | DELETE on SystemFE.Opt_Cost_Table and SystemFE.Opt_DBSCtl_Table or on SystemFE. |
Execution plans | DELETE on the QCD tables or on the QCD. EXECUTE on QCD macros. |
Object definitions | Sufficient DROP rights on the parent database or DELETE on the database object. |
RAS | DELETE on SystemFE.Opt_RAS_Table or on the SystemFE database. |
Statistics | All rights required to execute the DROP STATISTICS statement for the table or join index referenced. |
Demographics | DELETE on the data demographics table and corresponding views of the table. EXECUTE on demographics macros and QCD macros. |
QCD data | DELETE on QCD tables and views. EXECUTE on QCD macros. |
Workloads | DELETE on QCD tables and views. EXECUTE on QCD macros. |
Cost profiles | EXECUTE on the DBC.DeleteCostProfile macro. |
MH Maps | DELETE on SystemFE.Opt_Map_Table and SystemFE.Opt_MapRel_Table or on the SystemFE Database |