Which statement is correct?

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?

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.



Leave a Reply 1

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