Manipulate application roles

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

Create an application role

1. On the Database menu, select Security Manager.

2. Select the database where you want to create an application role.

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

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

4. On the General tab, fill out the fields: Name, Password, and Confirm Password.

5. In Default schema, select the schema to be used for this application role by default.

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

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

8. Click Save on the Security Manager toolbar.

Edit an application role

1. On the Database menu, select Security Manager.

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

3. Update the general details, owned schemas, 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 an application role

1. On the Database menu, select Security Manager.

2. Expand the Application Roles node.

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

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