Specific User Category Privileges - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ - Database Administration

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-03
dita:mapPath
tgx1512080410608.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval
dita:id
ujp1472240543947
Product Category
Software
Teradata Vantage

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