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. The DBA can revoke only ADMIN OPTION from USR1.
B. USR1 can revoke the CREATE VIEW privilege from USR3.
C. When the DBA revokes the CREATE VIEW privilege from USR1, it is revoked from USR2 but not USR3.
D. When USR1 revokes the CREATE VIEW privilege from USR2, it is revoked from USR3.
E. When the DBA revokes the CREATE VIEW privilege from USR1, it is revoked from USR2 and USR3.
F. When the DBA revokes the CREATE VIEW privilege from USR1, it is neither revoked from USR2 nor USR3.
大家讨论一下这道题目选什么呢?