nerdexam
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)
  • A
    16% (6)
  • B
    5% (2)
  • C
    71% (27)
  • E
    8% (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.

Full 1Z0-071 Practice