User OE, the owner of the ORDERS table, issues the following command: GRANT SELECT
.INSERT ON orders TO hr WITH GRANT OPTION; The user HR issues the following
command: GRANT SELECT ON oe. orders TO scott; Then, OE issues the following
command: REVOKE ALL ON orders FROM hr; Which statement is correct?
A.
The user SCOTT loses the privilege to select rows from OE.ORDERS.
B.
The user SCOTT retains the privilege to select rows from OE.ORDERS.
C.
The REVOKE statement generates an error because OE has to first revoke the SELECT
privilege from SCOTT.
D.
The REVOKE statement generates an error because the ALL keyword cannot be used
for privileges that have been granted using WITH GRANT OPTION.