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.