PLSQL-ISSUES,TRIGGERS, VIEWS AND INVOKER’S RIGHTS

ISSUES WITH INVOKER’S RIGHTS

Ø  In an invoker’s rights routine, external references in SQL statements will be resolved using the caller’s privilege set.

Ø  But references in PL/SQL statements are still resolved under the owner’s privilege set.

TRIGGERS, VIEWS AND INVOKER’S RIGHTS

Ø  A database trigger will always be executed with definer’s rights and will execute under the privilege set of the schema that owns the triggering table.

Ø  This is also true for PL/SQL function that is called from a view. In this case, the function will execute under the privilege set of the view’s owner.