16.00 - Creating an Aster Database - Teradata Studio

Teradata Studio User Guide

Teradata Studio
March 2017
User Guide
You must be connected to the Aster Database server before you can create an Aster database. A default database called beehive is created when Aster Database is initialized. To create your first user-defined database, you can connect to the beehive database. If at any time you need to undo your database definition, click Reset to delete your entries and begin again.
  1. In the Administration perspective, click an Aster connection.
  2. In the Navigator, double click on the Databases category to display the list of databases in the Object List Viewer.
  3. In the Object List Viewer toolbar, click (Create a new Aster database).
  4. In the Create Database form, click General and type a Name for the new database.
  5. [Optional] In Encoding, select the character set encoding to use for the new database.
  6. Click SQL.
    1. Review the generated statements that will create the new database.
    2. [Optional] Modify the CREATE statement by returning to previous steps to change your selections.
  7. Click Commit to create the database.
  8. [Optional] Click Privileges and define the privileges:
    Grantee Type Description
    Users Select a user to whom you want to grant rights for this database, then select the rights.
    Roles Select a role to which you want to grant rights for this database, then select the rights.
    Public Gives the public role to this database.
  9. Click SQL to review the generated SQL with added GRANT and REVOKE statements.
  10. 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.