Title: Identify differences between invoker and definer rights.
Course: Database Design and Management with PL/SQL (Oracle) (10053) > Section: Creating and Managing Functions

Identification should include

- defining definer in relation to a PL/SQL program
- explaining the way a program executes when definer’s rights are used:
  - The definer needs privileges on the database objects referenced by the subprogram.
  - The invoker needs EXECUTE privileges on the subprogram.

- defining invoker in relation to a PL/SQL program
- explaining the way a program executes when invoker’s rights are used:
  - The invoker needs EXECUTE privileges on the subprogram and needs privileges on the database objects referenced by the subprogram.
  - The definer does not need any privileges.

- reviewing examples in each scenario.