Specific User Category Privileges | Teradata Vantage - 17.00 - 17.05 - Specific User Category Privileges - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Database Administration

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
17.05
Published
June 2020
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
rgu1556127906220.ditamap
dita:ditavalPath
lze1555437562152.ditaval

The following table indicates the specific privileges granted to each user category.

User Category Database Object Type Privileges Granted
Normal QCD tables
  • INSERT
  • UPDATE
  • SELECT on the following tables.
    • IndexRecommendations
    • SeqNumber
    • TableStatistics
  • DELETE on the AnalysisLog table
X views SELECT
X macros EXEC
Non-X views None
Non-X macros None
Power QCD tables
  • INSERT
  • UPDATE
  • SELECT on the following tables:
    • IndexRecommendations
    • SeqNumber
    • TableStatistics
  • DELETE on the AnalysisLog table
X views SELECT
X macros EXEC
Non-X views SELECT
Non-X macros EXEC (excluding DELETE plan and workload macros)
Administrator QCD tables
  • DELETE
  • DROP
  • INSERT
  • SELECT
  • UPDATE
X views

X views use the value for UDB_Key in the Query table to restrict access to request plans to the user who captures them, while the Non-X views do not restrict that access.

  • DELETE
  • DROP
  • INSERT
  • SELECT
  • UPDATE
X macros
  • DROP
  • EXECUTE
Non-X views
  • DELETE
  • DROP
  • INSERT
  • SELECT
  • UPDATE
Non-X macros
  • DROP
  • EXECUTE