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 |