Oracle
1Z0-047 · Question #258
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…
The correct answer is A. The user SCOTT loses the privilege to select rows from OE.ORDERS. See the full explanation below for the reasoning.
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?
Options
- AThe user SCOTT loses the privilege to select rows from OE.ORDERS.
- BThe user SCOTT retains the privilege to select rows from OE.ORDERS.
- CThe REVOKE statement generates an error because OE has to first revoke the SELECT privilege
- DThe REVOKE statement generates an error because the ALL keyword cannot be used for privileges
How the community answered
(22 responses)- A77% (17)
- B5% (1)
- C14% (3)
- D5% (1)
Community Discussion
No community discussion yet for this question.