Views without Default PUBLIC Privileges | Teradata Vantage - Views for Which PUBLIC Privileges Are not Granted by Default - Advanced SQL Engine - Teradata Database

Data Dictionary

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-10-15
dita:mapPath
yoz1556235523563.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1092
lifecycle
previous
Product Category
Teradata Vantageā„¢

The system grants default access privileges on some views only to user DBC. These views contain security information or other data that is not for general use, so they are not included when the system grants default PUBLIC privileges on other views.

You must GRANT privileges to the following restricted views for any users or roles that need access to them.

  • DBC.AccessLog
  • DBC.AccLogRules
  • DBC.CSPSessionInfo
  • DBC.DBQLRules
  • DBC.DeleteAccessLog
  • DBC.DeleteOldInDoubt
  • DBC.InDoubtLog
  • DBC.LogonRules
  • DBC.QryLog
  • DBC.QryLogExceptions
  • DBC.QryLogExplain
  • DBC.QryLogEvents
  • DBC.QryLogObjects
  • DBC.QryLogSQL
  • DBC.QryLogSteps
  • DBC.QryLogSummary
  • DBC.QryLogTDWM
  • DBC.QryLogTDWMSum
  • DBC.SecurityLog
  • DBC.Software_Event_Log