Using the Administrative Functions

Teradata Visual Explain User Guide

brand
Teradata Tools and Utilities
prodname
Visual Explain
vrm_release
16.10
16.20
category
User Guide
featnum
B035-2504-086K

The table describes the privileges required to use the administrative features available in the Control Center area of Teradata Visual Explain.

Privileges for Control Center Features 
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