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 retains the privilege to select rows from OE.ORDERS.
B.
The REVOKE statement generates an error because OE has to first revoke the SELECT
privilege from SCOTT.
C.
The REVOKE statement generates an error because the ALL keyword cannot be used
for privileges that have been granted using WITH GRANT OPTION.
D.
The user SCOTT loses the privilege to select rows from OE.ORDERS.