The table describes the privileges required to use the administrative features available in the Control Center area of Teradata Visual Explain.
| Control Center Feature | Privileges Needed |
|---|---|
| Set up a new QCD | CREATE DATABASE CREATE TABLE CREATE MACRO on Teradata Database |
| The Upgrade/Revert feature of Manage QCD | CREATE TABLE CREATE MACRO DROP TABLE DROP MACRO UPDATE on the QCD |
| The Delete Execution Plans option in the Cleanup feature of Manage QCD | EXECUTE MACRO DELETE on the QCD |
| The Delete Database Objects option in the Cleanup feature of Manage QCD | DROP TABLE DROP MACRO DROP VIEW on the QCD |
| The Delete Entire Database option in the Cleanup feature of Manage QCD | DROP TABLE DROP MACRO DROP VIEW DROP DATABASE on the Teradata Database |
| The Create User feature in Security | CREATE USER on Teradata Database |
| The Change Privileges feature in Security | User must have the right being granted plus the GRANT privilege for that right on Teradata Database. |
| The Export QCD feature of Data Exchange | EXECUTE SELECT on the QCD |
| The Import QCD feature of Data Exchange | SELECT INSERT UPDATE on the QCD |