Manipulate roles

This topic describes how to create, edit, or delete roles visually using Security Manager without typing SQL code.

Create a role

1. On the Database menu, select Security Manager.

2. Select the database where you want to create a role.

3. Above the tree, click the arrow next to Create User and select Create Role.

Alternatively, right-click the Roles node and select New Role.

4. On the General tab, fill out the fields: Role name and Owner.

5. On the Owned Schemas tab, select schemas to be owned by the role.

6. On the Role Members tab, select users or roles to be assigned this role.

7. On the Object Permissions tab, grant privileges to the role. For more information, see Grant or revoke permissions on database objects.

8. Click Save on the Security Manager toolbar.

Edit a role

1. On the Database menu, select Security Manager.

2. Expand the Roles node, then select the role you want to edit.

3. Update the general details, owned schemas, role members, or object permissions as needed.

4. To apply the changes, click Save on the Security Manager toolbar.

To discard the changes, click Undo.

Tip

To view SQL statements that will apply your changes, click Script Changes on the Security Manager toolbar. The script opens in a new SQL document, where you can review, edit, and run it manually.

Delete a role

1. On the Database menu, select Security Manager.

2. Expand the Roles node.

3. Right-click the role you want to delete and select Delete.

Alternatively, select the role in the tree, then click Delete above the tree or press the Delete key.