Creating an Aster Schema - Teradata Studio

Teradata Studio IDE Plug-in User Guide

Product
Teradata Studio
Release Number
15.12
Published
August 2016
Language
English (United States)
Last Update
2018-05-03
dita:mapPath
pts1468860020550.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2043
lifecycle
previous
Product Category
Teradata Tools and Utilities
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.