这个权限不能授予role, 所以resource角色还会单授予unlimit tablespace权限(12c以后resource不会再同时授予unlimit tablespace)
因此通过dba_role_privs查看resource及dba角色均没有unlimit tablespace权限,但它们都通在授予角色时同时授予unlimited tablespace
如果将resource授予另一个角色newrole, 再授予newrole给scott,scott是没有unlimit tablespace的
create user hr identified by hr;
select * from dba_role_privs where grantee='HR'; --NULL
select * from dba_sys_privs where grantee='HR'; --NULL
grant resource to hr;
select * from dba_role_privs where grantee='HR'; --resource
select * from dba_sys_privs where grantee='HR'; --UNLIMITED TABLESPACE
select * from dba_sys_privs where grantee='RESOURCE';
GRANTEE PRIVILEGE ADM
------------------------------ ---------------------------------------- ---
RESOURCE CREATE TRIGGER NO
RESOURCE CREATE SEQUENCE NO
RESOURCE CREATE TYPE NO
RESOURCE CREATE PROCEDURE NO
RESOURCE CREATE CLUSTER NO
RESOURCE CREATE OPERATOR NO
RESOURCE CREATE INDEXTYPE NO
RESOURCE CREATE TABLE NO