Views without Default PUBLIC Privileges | VantageCloud Lake - Views for Which PUBLIC Privileges Are not Granted by Default - Teradata VantageCloud Lake

Lake - Database Reference

Deployment
VantageCloud
Edition
Lake
Product
Teradata VantageCloud Lake
Release Number
Published
February 2025
ft:locale
en-US
ft:lastEdition
2025-11-21
dita:mapPath
ohi1683672393549.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
ohi1683672393549

The system grants default access privileges only to user DBC on views that contain security information or other data that is not for general use, so these views 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