WITH GRANT OPTION

grant any privilege权限表示可以把任何系统权限grant/revoke他人(即使用户当前不包含此权限)
grant any object privilege权限表示可以把任何对象权限grant/revoke他人(即使用户当前不包含此权限)
同理grant any role

除了上面三个权限用户可以revoke所有权限，但一般revoke要满足：
1）对于系统权限：有grant .. with grant option就可以收回相应权限或角色，没必须是之前grant的用户
Any user with the ADMIN option for a system privilege or role can revoke the privilege or role from any other database user or role. 
The revoker does not have to be the user that originally granted the privilege or role.
2）对于对象权限：只有是之前授予用户才有权收回 （You previously granted the object privilege to the user or role.）
上面特点也导致如下：
system privilege的with admin option：A grant B，B grant C，A revoke B，C权限仍然在
object privilege的with admin option：A grant B，B grant C，A revoke B，C也被revoke
    另外WITH GRANT OPTION clause is not valid if you try to grant an object privilege to a role. 
另外object privs的另一特点:
    user1把hr.t1的select授予user3
    user2把hr.t1的select授予user3
    user1收回user3的权限后,user3仍有访问hr.t1的权限

视图与with grant option: 授予视图需要对应基表有with grant option权限
conn c##user1/oracle
create table t1(id number);
grant all on t1 to c##user2;

conn c##user2/oracle
create view v1 as select * from c##user1.t1;
grant select on v1 to c##user3;
ORA-01720: grant option does not exist for 'C##USER1.T1'