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:
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.