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.