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:
- Start Teradata SET 16.20.
-
Select
from the menu.
The Options dialog box appears.
- Select the Customize tab.
- Select Use X views (DBC and QCD).
- Connect to the database. A confirmation message appears.
- Click Yes to create the restricted views.