Submitted by: Michael Trowe (bubble76)

Assigned to: Claudio Valderrama C. (robocop)

If you try to grant a role to a user and you have no admin-option for this role, an exception is raised.
If you try to revoke a role from a user without admin-options for this role, nothing happens - and I think the same exception must be raised.

Example:

CREATE ROLE ROLE_1;
CREATE ROLE ROLE_2;

/* Privileges of users */
GRANT ROLE_1 TO USER_1 WITH ADMIN OPTION;
GRANT ROLE_2 TO USER_1;

**** Login as USER_1 ****
GRANT ROLE_1 TO USER_2
REVOKE ROLE_1 FROM USER_2

GRANT ROLE2 TO USER_2
** The exception raised

**** Login as SYSDBA ****
GRANT ROLE_2 TO USER_2;

**** Login as USER_1 ****
REVOKE ROLE_2 FROM USER_2
** Nothing happens