Oracle 9i Fundamentals I Exam Cram™ 2 (Exam 1Z0-031)

Creating and Modifying Roles

When you create a role, you use the CREATE ROLE statement. Further, you need to have the CREATE ROLE system privilege to be able create roles in the database. You can either create a role as NOT IDENTIFIED, IDENTIFIED EXTERNALLY, IDENTIFIED BY PASSWORD, GLOBALLY, or USING PACKAGE. The default is NOT IDENTIFIED.

The general command used to create a role is as follows:

					CREATE ROLE
					rolename
					[NOT IDENTIFIED | IDENTIFIED
					{BY
					password
					| EXTERNALLY |GLOBALLY | USING
					package_name}]
				

The role name is the name that you assign to the role and must be unique among all existing role names and usernames in the database. If you are working in a database that uses a multibyte character set, Oracle strongly suggests that the role ...