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.
Starting 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 Teradata Vantage™ - Data Dictionary, B035-1092 and Teradata Vantage™ - Database Administration, B035-1093.
Additional restricted views required by Teradata SET must be created in the 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\17.10\bin\DBCVXViews141.bteq
To create restricted views:
- Start Teradata SET 17.10.
- Select .
- Click the Customize tab.
- Select Use X views (DBC and QCD).
- Connect to the database.
- Click Yes to create the restricted views.