grant alter any table on username with admin option;用户权限

grant alter any table on username with grant option;系统权限

角色是权限的集合

创建角色：create role myrole

授权：grant create session to myorle ;

角色赋予用户：grant myrole to username;

***角色：drop role myrole

无法将不限定表空间的权限赋予给角色：grant unlimited tablespace to myrole ;

ORA-01931:无法将unlimited tablespace to myrole 授予角色；