Tom,

I have a question regarding the RESOURCE built-in role. It seems that the privilege 'UNLIMITED TABLESPACE' is given to a user when I grant them the 'RESOURCE' role, but I don't see 'UNLIMITED TABLESPACE' as one of the privilges.

select privilege from dba_sys_privs where grantee = 'RESOURCE';

PRIVILEGE
----------------------------------------
CREATE TRIGGER
CREATE SEQUENCE
CREATE TYPE
CREATE PROCEDURE
CREATE CLUSTER
CREATE OPERATOR
CREATE INDEXTYPE
CREATE TABLE


Please explain why 'UNLIMITED TABLESPACE' is granted when 'RESOURCE' is granted to the user.
'UNLIMITED TABLESPACE' is a system privilege, right?