16.10 - Specific User Category Privileges - Teradata Database

Teradata Database Administration

Product
Teradata Database
Release Number
16.10
Release Date
April 2018
Content Type
Administration
Publication ID
B035-1093-161K
Language
English (United States)

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