You have been asked to create three users, PUB1, PUB2 and PUB3, for three newly hired employees and to allocate unlimited quota on their default tablespace PUBLISHER_TBS with no other privileges. After creating the users, which method can you use for granting the required privileges?()
A:grant CONNECT role to all of the three users
B:grant RESOURCE role to all of the three users
C:grant both CONNECT and RESOURCE role to all of the three users
D:execute ALTER USER .. QUOTA UNLIMITED ON publisher_tbs command for all of the three users
E:create role with UNLIMITED TABLESPACE system privilege and assign the role to all of the three users
出自:Oracle认证