Chapter 4. Invoker's-Rights Architecture
Managing PL/SQL code libraries in the database requires planning and organization. Oracles 8i through Oracle 10g databases provide two options for organizing code libraries. The options are definer's-rights and invoker's-rights. This chapter discusses how you implement the invoker's-rights option.
Oracle has always had definer's-rights architecture as the default. Oracle 8i introduced invoker's-rights architecture. Many ERP/CRM database applications use invoker's-rights concepts. You can build robust applications with definer's-rights architecture when working with centralized data.
The Oracle Applications Suite uses definer's-right architecture to share common code components and manage internal component ...
Get Expert Oracle PL/SQL now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
