Advantages of invoker rights, PL-SQL Programming

Advantages of Invoker Rights

The Invoker-rights routines centralize the data retrieval. They are particularly helpful in applications which store data in various schemas. In such situations, the multiple users can manage their own data using the single code base.

Consider a company which uses a definer-rights procedure to analyze the sales. To provide the local sales statistics, the procedure analyze should access the sales tables that exist in at each regional site. Therefore, as figure shows, the procedure should also exist in at each regional site. That causes a maintenance trouble.

1298_advantages of invoker rights.png

Figure: Definer Rights Problem

To resolve the problem, the company installs invoker-rights version of procedure analyzes at the headquarters. Now, as figure shows, all the regional sites can use similar procedure to query their own sales tables.

1426_advantages of invoker rights1.png

Figure: Invoker Rights Solution

The Invoker-rights routines also restrict the access to the sensitive data. Assume that the headquarters would like procedure analyze to compute the sales commissions and update the central payroll table.

That represents a problem as invokers of analyze must not have the direct access to the payroll table that stores the employee salary and other sensitive data. As figure shows, the answer is to have procedure analyze to call the definer-rights procedure calc_comm that in turn updates the payroll table.

605_advantages of invoker rights2.png

Figure: Indirect Access

Posted Date: 10/5/2012 5:43:37 AM | Location : United States







Related Discussions:- Advantages of invoker rights, Assignment Help, Ask Question on Advantages of invoker rights, Get Answer, Expert's Help, Advantages of invoker rights Discussions

Write discussion on Advantages of invoker rights
Your posts are moderated
Related Questions
Using INNER JOIN INNER JOIN is used to retrieve the data from all tables listed based on a condition of equality listed after keyword ON. If the condition is not meet, rows ar

Product-specific Packages The Oracle and different Oracle tools are supplied with the product-specific packages which help you to build the PL/SQL-based applications. For illu

Definition of FROM - SQL Recall that the operand of FROM is denoted by a commalist, each element of that commalist being a table expression optionally accompanied by a range v

Parameter and Keyword Description: select_item: This select_item is a value returned by the SELECT statement, and then assigned to the equivalent variable or field in the

What Is a Package? The package is a schema object that group logically related PL/SQL items, types, and subprograms. The Packages usually have 2 parts, a specification & a bo

Recursion versus Iteration Dissimilar the iteration, recursion is not crucial to PL/SQL programming. Any problem which can be solved using recursion can be solving using the it

Data Types in SQL - Integer INTEGER or  synonymously INT, for integers within a certain range. SQL additionally has types SMALLINT and BIGINT for certain ranges of integers. T

INSERT Statement The INSERT statement adds fresh rows of data to the specified database table or view. Syntax:

Methods: In normal, a method is a subprogram declared in an object type specification using the keyword MEMBER or STATIC. The method cannot have similar name as the object typ

Enrolment was split - SQL Example shows how relvars IS_CALLED and IS_ENROLLED_ON can be derived from the original ENROLMENT relvar, using projection in the initial assignment