16.00 - Creating an Aster Schema - Teradata Studio

Teradata Studio User Guide

Teradata Studio
March 2017
User Guide
You must define at least one schema in an Aster database before you can create tables, views, or other objects or move data.
  1. In the Administration perspective, click an Aster connection.
  2. In the Navigator, double-click on the database in which you want to create the schema. The list opens in the Object List Viewer.
  3. In the Object List Viewer, display the schema list and click .
  4. In the Create Schema form, click General and type a Name for the new schema.
  5. Click SQL.
    1. Review the generated SQL statements that will create the new schema.
    2. [Optional] Modify the CREATE statement by returning to previous steps to change your selections.
  6. Click Commit to create the schema.
  7. [Optional] Click Privileges and define the privileges:
    Grantee Type Description
    Users Select a user to whom you want to grant rights for this schema, then select the rights.
    Roles Select a role to which you want to grant rights for this schema, then select the rights.
    Public Gives the public role to this schema.
  8. Click SQL to review the generated SQL with added GRANT and REVOKE statements.
  9. Click Commit to set the privileges you selected for this schema.
    You can change any privilege you've set by returning to the Privileges tab and double-clicking a privilege icon.