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.
- 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.
-
In the Object List Viewer toolbar, click .
A Create Role property form opens in the Details view.
- 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.
- Click OK. The property form shows the properties of the new role.