Table 24 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 |