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

Teradata® Studio™ User Guide

Product
Teradata Studio
Release Number
17.00
Published
January 2021
Language
English (United States)
Last Update
2021-01-11
dita:mapPath
lex1576517377362.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2041
lifecycle
previous
Product Category
Teradata Tools and Utilities
Define at least one schema in an Aster database before you create tables, views, or other objects or move data.
  1. In the Navigator, double-click Databases.
  2. In the Object List Viewer:
    1. Double-click the database in which you want to create a new schema.
    2. Click "" .
  3. In the Create Schema form, type a Name for the new schema.
  4. 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.
  5. Click Commit.
    You can now assign privileges to the schema.
  6. [Optional] Click Privileges 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 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.
  7. Click SQL to review the generated SQL with added GRANT and REVOKE statements.
  8. Click Commit.