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

Teradata® Studio™ User Guide - 17.20

Product
Teradata Studio
Release Number
17.20
Published
September 2022
Language
English (United States)
Last Update
2022-09-23
dita:mapPath
gvw1648839236371.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2041
Product Category
Teradata Tools and Utilities
After you create an Aster Database role, you can use that role across all databases residing on the same Aster Database server.
  1. In the Navigator, double-click Roles.
  2. In the Object List Viewer, click "" .
  3. In the Create Role form, click General and type a Name for the new role.
  4. [Optional] Select the Inherit check box to specify this role inherits the privileges of roles of which it is a member.
  5. Click SQL.
    1. Review the generated statements that will create the new role.
    2. [Optional] Modify the CREATE statement by returning to previous steps to change your selections.
  6. Click Commit to create the role.
    Detailed role information and privileges can now be assigned to the user.
  7. [Optional] Click In Roles and specify to which roles the new role is a member of.
  8. [Optional] Click Members of Role and select the Member Type.
  9. [Optional] Click Object Privileges and define the privileges.
    Select the object to which you want to grant rights by this role and next specify the privileges to grant to this role by selecting the check boxes beside the object.
  10. [Optional] Click SQL to review the generated SQL with added GRANT and REVOKE statements.
  11. Click Commit to set the privileges you selected for this role.