Prev Question
Next Question

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.

Prev Question
Next Question

Leave a Reply

Your email address will not be published. Required fields are marked *