Roles Wizard (Oracle)

From RapidSQL
Jump to: navigation, search

Go Up to Oracle Object Wizards

The Role Wizard constructs the necessary CREATE ROLE statement from the information that you have supplied. The Role Wizard lets you specify a name for the role and whether or not the role should be identified.

Note: To create a role, you need the CREATE ROLE system privilege.

To Open the Role Wizard

  1. On the Navigator, find the datasource where you want to create a role and expand the Security node.
  2. Right-click the Roles node, and select New.

The table that follows describes the fields you may encounter as you complete the wizard.

Required Information Description

What is the name of the role?


How should the role be identified?

Not identified - Selecting this means the role you are creating will be enabled immediately. Identified: If this is your choice, you’re indicating one of the following authorization methods will be followed: Globally - Select to indicate that Oracle permits access to the user by obtaining user name and password information from the security domain central authority. Externally - Select to indicate that Oracle should verify the database user name against an existing operating system user name. Password - Select to indicate that Oracle should identify the role with the password you provide. In the Password box, type the password for the user.

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