Creating Restricted Views - System Emulation Tool

Teradata System Emulation Tool User Guide

Product
System Emulation Tool
Release Number
16.20
Published
October 2018
Language
English (United States)
Last Update
2018-10-12
dita:mapPath
gnf1527114222337.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2492
lifecycle
previous
Product Category
Teradata Tools and Utilities
Restricted DBC database views can be created to limit access to information. Restricted DBC views are identified by the suffix X and are called X views.

Teradata SET uses restricted views to restrict access to data dictionary information and QCD data the logged in user owns or has access to.

Beginning with Teradata Database 12.00.00, each system view in the DBC database includes a view that supports UnicodeĀ®. All UnicodeĀ® system views are identified by a suffix, V or VX, when a restricted UnicodeĀ® view is used.

To learn more about X views, V views, and VX views, see Data Dictionary (B035-1092) and Database Administration (B035-1093).
Additional restricted views required by Teradata SET must be created in Teradata Database. Teradata SET creates restricted views from a script file. There are five versions of the script file:
  • DBCXViews62.bteq; used on Teradata Database V2R6.2, V2R6.1, or V2R6.0
  • DBCVXViews120.bteq; used on Teradata Database 12.00.00
  • DBCVXViews130.bteq: used on Teradata Database 13.00.00 and Teradata Database 13.10.00
  • DBCVXViews140.bteq: used on Teradata Database 14.0
  • DBCVXViews141.bteq; used on Teradata Database 14.10 and higher

The script files are located in the Teradata installation folder; for example, C:\Program Files(x86)\Teradata\Client\16.20\bin\DBCVXViews141.bteq

To create restricted views:

  1. Start Teradata SET 16.20.
  2. Select Tools > Options from the menu.

    The Options dialog box appears.

  3. Select the Customize tab.
  4. Select Use X views (DBC and QCD).
  5. Connect to the database. A confirmation message appears.
  6. Click Yes to create the restricted views.