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…

Question

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 from
• DThe REVOKE statement generates an error because the ALL keyword cannot be used for privileges

• A
  80% (24)
• B
  10% (3)
• C
  3% (1)
• D
  7% (2)

No community discussion yet for this question.