Manipulating Roles

This topic tells you how to manipulate roles with Security Manager of dbForge Fusion for Oracle.

Security Manager provides an easy way to add, alter or remove roles visually without typing SQL code. To open Security Manager, select Security Manager from the Tools -> dbForge Fusion for Oracle -> Database menu.

Creating a Role

  1. Open Security Manager.
  2. Select the Roles node.
  3. Right-click the Roles node and select New Role from the shortcut menu.
  4. Fill the Name field.
  5. Select authentication method. If you have selected the Database method, fill the Password and Confirm Password fields.
  6. Grant necessary roles and privileges to role.
  7. Click Save on the Security Manager toolbar.

Editing a Role

Open Security Manager, expand the Roles node and select a required role in the tree. After editing, click Save on Security Manager toolbar to apply changes. If you want to discard changes, click Undo on the Security Manager toolbar.

Deleting a Role

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