Undo‑Import Rights
The Undo-Import Rights 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. |