Working with Multiple Users

dbForge Studio for Oracle provides possibility to work with multiple users or roles in Security Manager. This feature is useful if you need to add the same privileges or roles for several users or roles.

To select multiple users or roles:

  • Press Ctrl and select users/roles

    or

    Select the first user/role, press Shift, and click the last user or role (if users or roles are located one by one).

    For several users or roles, you can edit roles, system and object privileges on the corresponding Security Manager tabs. Note that the General and Quota tabs are unavailable in this case.

The following identifications define the state of privileges:

  • for global privileges:

    - the privilege is assigned to all selected users;

    - the privilege is assigned not to all selected users;

    - the privilege is not assigned to any of the selected users;

  • for object privileges:

    - the privilege is assigned to all selected users;

    - the privilege is assigned not to all selected users.

Want to Find out More?

Overview

Overview

Take a quick tour to learn all about the key benefits delivered by dbForge Studio for Oracle.
All Features

All features

Get acquainted with the rich features and capabilities of the Studio in less than 5 minutes.
Request a demo

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?