16.00 - Creating an Aster View - Teradata Studio

Teradata Studio User Guide

Teradata Studio
March 2017
User Guide
  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.