Creating an Aster Database User - 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
  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.