Roles Editor (Oracle)

From RapidSQL
Jump to: navigation, search

Go Up to Oracle Object Editors

The Roles Editor lets you manage authentication and grant/revoke profiles for users and logins.

To edit a role

  1. Open an editor on the role. For details, see Opening an Object Editor.
  2. Use the following table as a guide to understanding and modifying the settings on the tabs of this editor:
Tab Settings and tasks


Lets you manage role identity. When creating a role, you must establish certain rules governing its use. You can specify whether or not a role must be identified when used. If you require role identification, you can authenticate the user externally through the operating system, or with a specific password. If you specified that the role requires identification, provide a Password and specify whether the role is to be authenticated Globally or Externally.


Displays permissions for this role to logins or users. Click Grant to open a dialog that lets you grant this role to a login or another role. Select a role or login and click Revoke to revoke the role or login.

Object Privileges and System Privileges

For details on using this tab, see Working with Privileges and Permissions.

DDL View

For details on using this tab, see Viewing the SQL/DDL for an Object.

3. When finished, you can submit your changes. For details, see Previewing and Submitting Object Editor Changes.

For information on activating and deactivating roles for the current login in the current session, see Role Activation.