O'Reilly logo

Expert Oracle PL/SQL by Michael McLaughlin, Ron Hardman

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required