16.00 - Creating an Aster Database User - Teradata Studio

Teradata Studio User Guide

Teradata Studio
March 2017
User Guide
  1. In the Administration perspective, click an Aster connection and choose the Users category.
  2. In the Object List Viewer toolbar, click .
  3. In the Create User form, click General and type a Name for the new user.
  4. Assign and confirm a password.
  5. [Optional] Select Inherit so this user automatically inherits group privileges.
  6. Click SQL.
    1. Review the generated statements that will create the new user.
    2. [Optional] Modify the CREATE statement by returning to previous steps to change your selections.
  7. Click Commit to create the user.
  8. [Optional] Click In Roles and specify roles for this user.
    Role Name Description
    In Role User is member of the role.
    Not in Role User is not a member of the role.
    Add to Role User selected to be added as a member of the role.
    Remove from Role User selected to be removed as a member of the role.
  9. [Optional] Click Object Privileges and define the privileges:
    1. Select the Object Type.
    2. Select the Database that contains the objects on which you want to set privileges for the user or select ALL.
    3. Set the privilege for each object you select in the Object Name column.
  10. Click SQL to review the generated SQL.
  11. Click Commit.