As the DBA, you execute this command: GRANT CREATE VIEW TO USr1 WITH ADMIN OPTION; USR1 then executes this command; GRANT CREATE VIEW TO USr2 WITH ADMIN OPTION; USR2 then executes this command; GRANT CREATE VIEW TO usr3; Which statement is true?

【单选题】
A USR1 can revoke the CREATE VIEW privilege from USR3
B The DBA can revoke only ADMIN OPTION from USR1.
C When the DBA revokes the CREATE VIEW privilege from USR1, it is revoked from USR2 but not USR3.
D When the DBA revokes the CREATE VIEW privilege from USR1, it is neither revoked from USR2 nor USR3.
E When the DBA revokes the CREATE VIEW privilege from USR1, it is revoked from USR2 and USR3
F When USR1 revokes the CREATE VIEW privilege from USR2, it is revoked from USR3.

查看更多