Manipulating Application Roles

Security Manager provides an easy way to add, alter or remove application roles visually without typing an SQL code. To open Security Manager, on the Database menu, select Security Manager.

Creating a new role

  1. Open Security Manager.
  2. Click the Create Application Role button above the User List. Alternatively, right-click a role, and then select New Application Role from the shortcut menu.
  3. Fill the Name, Password, Confirm Password fields.
  4. Specify a default schema.
  5. Grant necessary permissions to an application role and specify owned schemas.
  6. Click the Save button on the Security Manager toolbar.

Editing an Application Role

To edit an application role account, open Security Manager, expand the Application Roles node, and select a required application role in the tree. After editing, click the Save button on the Security Manager toolbar to apply your changes. If you want to discard the changes, click the Undo button on the Security Manager toolbar.

Deleting an Application Role

Open Security Manager, expand the Application Roles node, and then select Delete from the shortcut menu of a required application role; or select a required application role in the tree, and then press DELETE.