Manipulating Roles

This topic tells you how to manipulate roles with dbForge Studio Security Manager.

Note

The Role Editor is available for the MariaDB connections only.

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

Creating a new role

  1. Open Security Manager.
  2. Click the Create Role button above the User List. Alternatively, right-click a role and then select New Role on the shortcut menu.
  3. Fill the Name field.
  4. Grant necessary roles and permissions to a role.
  5. Click the Save button on the Security Manager toolbar.

Editing a role

To edit a role account, open Security Manager, expand the Roles node, and then select a required role in the tree. After editing, click the Save button on the Security Manager toolbar to apply changes.

If you want to discard changes, click the Undo button on the Security Manager toolbar.

Deleting a role

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