Creating an Aster View - Teradata Studio

Teradata Studio User Guide

Product
Teradata Studio
Release Number
15.11
Published
May 2016
Language
English (United States)
Last Update
2018-05-03
dita:mapPath
bpb1467322243715.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2041
lifecycle
previous
Product Category
Teradata Tools and Utilities
  1. In the Administration perspective, click an Aster connection.
  2. In the Navigator, double-click on the Databases category. The database list opens in the Object List Viewer.
  3. Locate the database and schema where you want to create a view.
  4. In the Object List Viewer, click .
  5. In the Create View form, click General and type a Name for the new view.
  6. Click the View Query tab.
  7. Specify one or more source tables in the SELECT * FROM clause.
  8. Click SQL.
    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.
  9. Click Commit to create the view.
  10. [Optional] Click Privileges and 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.
  11. Click SQL to review the generated SQL with added GRANT and REVOKE statements.
  12. Click Commit to set the privileges you selected for this database.
    You can change any privilege you've set by returning to the Privileges tab and double-clicking a privilege icon.