15.00 - Creating Restricted Views - System Emulation Tool

Teradata System Emulation Tool User Guide

System Emulation Tool
User Guide

Creating Restricted Views

Restricted DBC database views can be created to limit access to information. Restricted DBC views are identified by the suffix X and 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.

Note: 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 15.0
  • The script files are located in the Teradata installation folder. For example:
    C:\Program Files\Teradata\Teradata System Emulation Tool 15.0\DBCVXViews141.bteq


    To create restricted views

    1 Start Teradata SET 15.00.

    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.