Oracle
1Z0-071 · Question #300
Which two are true about granting privileges on objects? (Choose two.)
The correct answer is C. A table owner must grant the REFERENCES privilege to allow other users to create FOREIGN D. The owner of an object acquires all object privileges on that object by default. https://docs.oracle.com/cd/B19306_01/network.102/b14266/authoriz.htm#i1008214
Controlling User Access
Question
Which two are true about granting privileges on objects? (Choose two.)
Options
- AAn object privilege can be granted to other users only by the owner of that object.
- BAn object privilege can be granted to a role only by the owner of that object.
- CA table owner must grant the REFERENCES privilege to allow other users to create FOREIGN
- DThe owner of an object acquires all object privileges on that object by default.
- EThe WITH GRANT OPTION clause can be used only by DBA users.
How the community answered
(38 responses)- A16% (6)
- B5% (2)
- C71% (27)
- E8% (3)
Explanation
https://docs.oracle.com/cd/B19306_01/network.102/b14266/authoriz.htm#i1008214
Topics
#object privileges#GRANT#REFERENCES privilege#WITH GRANT OPTION
Community Discussion
No community discussion yet for this question.