16.20 - Querying X Versus Non-X Views - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ Data Dictionary

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
zzu1512081120577.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval
The amount of information that can be retrieved from system views at a particular site depends on:
  • Whether an X version is available for a particular view
  • The privilege granted, if any, on each available view
  • Whether the statement references “view_name” or “view_nameX”

Assuming that both the X and non-X versions of the views are installed, and that the SELECT privilege is granted to PUBLIC on both versions, the information returned by an unconditional SELECT depends on the specified view name, as follows:

A view specified as … Returns information about …
DBC.viewname all objects for which entries exist in the underlying table.
Unconditional SELECTs on non-X views may cause the result to exhaust the available spool space of the user.
DBC.viewnameX only those objects that the requesting user:
  • owns
  • created
  • has been granted privileges on
  • has access to via current role and the current nested roles of the role