16.00 - Creating a Role - Teradata Studio

Teradata Studio User Guide

prodname
Teradata Studio
vrm_release
16.00
created_date
March 2017
category
User Guide
featnum
B035-2041-126K
A role defines a set of database privileges on database objects. A user who is assigned a role automatically gains all the privileges of that role. For more information on roles and privileges, see SQL Fundamentals, SQL Data Control Language, and SQL Data Definition Language - Syntax and Examples.
  1. In the Navigator, right-click Roles, and click Show Roles. A list of the roles defined in the connected system appears in the Object List Viewer. The list is filtered according to any filters you have applied.
  2. In the Object List Viewer toolbar, click .

    A Create Role property form opens in the Details view.

  3. In the property form, enter property values for the new role.
  4. [Optional] Click the SQL tab to see the SQL code that will be executed on the connected system to create the new role.
  5. Click Commit.
  6. Click OK. The property form shows the properties of the new role.