Create an Aster Database | Teradata Studio - Creating an Aster Database - 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
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 Navigator, double-click Databases.
  2. In the Object List Viewer toolbar, click "" .
  3. In the Create Database form, type a Name for the new database.
  4. [Optional] In Encoding, select the character set encoding to use for the new database.
  5. 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.
  6. Click Commit to create the database.
    Privileges can be now be assigned to the new database.
  7. [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 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.
  8. Click SQL to review the generated SQL with added GRANT and REVOKE statements.
  9. Click Commit.