Specific User Category Privileges | Teradata Vantage - Specific User Category Privileges - Analytics Database - Teradata Vantage

Database Administration

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-11-03
dita:mapPath
pgf1628096104492.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
ujp1472240543947
lifecycle
latest
Product Category
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