Oracle
1Z0-071 · Question #36
The user SCOTT who is the owner of ORDERS and ORDER_ITEMS tables issues the following GRANT command: GRANT ALL ON orders, order_items TO PUBLIC; What correction needs to be done to the above…
The correct answer is D. Separate GRANT statements are required for ORDERS and ORDER_ITEMS tables. See the full explanation below for the reasoning.
Question
The user SCOTT who is the owner of ORDERS and ORDER_ITEMS tables issues the following GRANT command:
GRANT ALL ON orders, order_items TO PUBLIC; What correction needs to be done to the above statement?
Options
- APUBLIC should be replaced with specific usernames.
- BALL should be replaced with a list of specific privileges.
- CWITH GRANT OPTION should be added to the statement.
- DSeparate GRANT statements are required for ORDERS and ORDER_ITEMS tables.
How the community answered
(25 responses)- A8% (2)
- B4% (1)
- C12% (3)
- D76% (19)
Community Discussion
No community discussion yet for this question.