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
Teradata Vantage™ SQL Fundamentals, B035-1141,
Teradata Vantage™ SQL Data Control Language, B035-1149, and
Teradata Vantage™ SQL Data Definition Language Syntax and Examples, B035-1144.
- In the Navigator, double-click Roles.
-
In the Object List Viewer toolbar, click
.
- In the property form, enter property values for the new role.
- [Optional] Click the SQL tab to see the SQL code that will be executed on the connected system to create the new role.
- Click Commit then OK.