Create an Aster View | Teradata Studio - Creating an Aster View - Teradata Studio

Teradata® Studio™ User Guide

Product
Teradata Studio
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-20
dita:mapPath
rvy1605890559220.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2041
lifecycle
previous
Product Category
Teradata Tools and Utilities
  1. In the Navigator, double-click Databases.
  2. In the Object List Viewer:
    1. Locate the database containing the schema where you want to create a view.
    2. Right-click the schema and click Show Views.
    3. Click "" .
  3. In the Create View form, type a Name for the new view.
  4. Click the View Query tab and specify one or more source tables in the SELECT * FROM clause.
  5. Click the SQL tab.
    1. Review the generated statements that will create the new view.
    2. [Optional] Modify the CREATE statement by returning to previous steps to change your selections.
  6. Click Commit to create the view.
    Privileges can now be assigned to the view.
  7. [Optional] Click the Privileges tab and select a Grantee Type to define the privileges:
    Grantee Type Description
    Users Select a user to whom you want to grant rights for this view, then select the rights.
    Roles Select a role to which you want to grant rights for this view, then select the rights.
    Public Gives the public role to this view.
  8. Click the SQL tab to review the generated SQL with added GRANT and REVOKE statements.
  9. Click Commit.