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

Granting Roles

Assigning roles to a user uses the same syntax as the command that is used to grant a system privilege to the user, regardless of what privileges are in the role.

The following command would grant the developer role to Amandya WITH ADMIN OPTION:

					GRANT ROLE
					developer
					TO
					Amandya
					WITH ADMIN OPTION;
				

The user who creates the role is implicitly assigned WITH ADMIN OPTION. Any user who has been granted a role but has not been granted it WITH ADMIN OPTION requires the GRANT ANY ROLE system privileges to grant or revoke the role to and from other users.

The maximum number of database roles that any user can enable is set by the MAX_ENABLED_ROLES ...