Roles Wizard (Oracle)

Go Up to Oracle Object Wizards

The Roles izard constructs the necessary CREATE ROLE statement from the information that you supplied. The Roles izard lets you specify a name for the role and whether the role should be identified.

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

To open the Roles wizard

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

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

Required Information	Description
What is the name of the role?	Self-explanatory.
How should the role be identified?	Not identified. Specifies that the role you are creating is immediately enabled. Identified. Indicates the use of one of the following authorization methods: Globally. Indicates that Oracle permits access to the user by obtaining user name and password information from the security domain central authority. Externally. Indicates that Oracle should verify the database user name against an existing operating system user name. Password. Indicates 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.