Using the Administrative Functions - 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