Manipulating Roles
This topic tells you how to manipulate roles with dbForge Studio for Oracle Security Manager.
Security Manager provides an easy way to add, alter or remove roles visually without typing SQL code. To open Security Manager, select Security Manager on the Database menu.
Creating a Role
- Open Security Manager.
- Select the Roles node.
- Right-click the Roles node and select New Role on the shortcut menu.
- Fill in the Name field.
- Select authentication method. If you have selected the Database method, fill in the Password and Confirm Password fields.
- Grant necessary roles and privileges to role.
- Click the Save button on the Security Manager toolbar.
Editing a Role
You can edit role account by opening Security Manager, expanding Roles node and selecting required role in the tree. After editing you should 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 the Security Manager, expand the Roles node and select Delete on the shortcut menu of the required role, or select a required role in the tree and press DELETE.
Want to Find out More?
Overview
Take a quick tour to learn all about the key benefits delivered by dbForge Studio for Oracle.
All features
Get acquainted with the rich features and capabilities of the Studio in less than 5 minutes.
Request a demo
If you consider employing the Studio for your business, request a demo to see it in action.
Ready to start using dbForge Studio for Oracle?