nerdexam
Oracle

1Z0-074 · Question #100

In which two situations does the INHERIT ANY PRIVILIGES privilege regulate the privileges used?

The correct answer is C. when a user queries a BEQUEATH CURRENT_USER view that references an invoker's right D. when a user runs a procedure created with invoker's right. Explanation/Reference: https://docs.oracle.com/database/121/DBSEG/dr_ir.htm#DBSEG661

New Features for Security

Question

In which two situations does the INHERIT ANY PRIVILIGES privilege regulate the privileges used?

Options

  • Awhen a user creates a new user
  • Bwhen a user performs a GRANT or REVOKE operation
  • Cwhen a user queries a BEQUEATH CURRENT_USER view that references an invoker's right
  • Dwhen a user runs a procedure created with invoker's right
  • Ewhen a user runs a procedure created with definer's right

How the community answered

(24 responses)
  • A
    8% (2)
  • B
    4% (1)
  • C
    75% (18)
  • E
    13% (3)

Explanation

Explanation/Reference: https://docs.oracle.com/database/121/DBSEG/dr_ir.htm#DBSEG661

Topics

#INHERIT ANY PRIVILEGES#invoker's rights#definer's rights#privilege inheritance

Community Discussion

No community discussion yet for this question.

Full 1Z0-074 Practice