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
正确答案:D
答案解析:有
微信扫一扫手机做题