Execute privilege, PL-SQL Programming

EXECUTE Privilege

To call an invoker-rights routine straightforwardly, the users should have the EXECUTE privilege on that routine. By yielding the privilege, you permit a user to

(i)                 Call the routine straightly

(ii)                Compile the functions and procedures which call the routine

Assume that the user till grants the EXECUTE privilege on invoker-rights routine fft to the user app, as shown below:

GRANT EXECUTE ON util.fft TO app;

Now, the user app can compile the functions & procedures which call the routine fft. At run time, no privilege checks on the calls are completed. So, as figure shows, the user need not grant the EXECUTE privilege to every user who may call the fft indirectly.

307_execute previlige.png

Figure: Indirect Calls to an Invoker-Rights Routine

Note that that routine till fft is called directly only from the definer-rights routine app.entry. Therefore, the user till should grant the EXECUTE privilege only to the user app. When util.fft is executed, its invoker may be scott, app, or blake.

Posted Date: 10/5/2012 5:45:47 AM | Location : United States







Related Discussions:- Execute privilege, Assignment Help, Ask Question on Execute privilege, Get Answer, Expert's Help, Execute privilege Discussions

Write discussion on Execute privilege
Your posts are moderated
Related Questions
Using Subqueries A subquery is a query (typically enclosed by parentheses) that appears within another SQL data manipulation statement. If evaluated, the subquery gives a va

Using PRIOR and NEXT The PRIOR(n) returns the index number that precede index n in a collection. The NEXT(n) returns the index number which succeed the index n. If n has no pr

Introduction Oracle 9i - it was made public in the year 2001 with over 400 features, and graphics, it has merged the traditional business with modern internet application

PPD , CPA, Filesharing Site Project Description: This is very easy I need a PPD , CPA, Filesharing Site. [PPD] stands for (pay per download) example hotsharecash [Files

LONG and LONG RAW You use the LONG datatype to store the variable-length character strings. The LONG datatype is such as the VARCHAR2 datatype, except that the maximum length o

FORALL Statement The FORALL statements instruct the PL/SQL engine to bulk-bind the input collections before sending them to the SQL engine. Though the FORALL statement consists

Constants and Variables:   You can declare the constants and variables in the declarative section of any PL/SQL subprogram, block, or package. The Declarations allot the stor

Row Counterparts of Table Operators SQL does not have counterparts tuple rename, tuple projection, tuple extension, tuple join and tuple compose. To obtain the same effects as

Semidifference via EXCEPT and JOIN - SQL SELECT * FROM (SELECT StudentId FROM IS_CALLED WHERE Name = 'Devinder' EXCEPT DISTINCT CORRESPONDING SELECT StudentId

V ariables and Constants in PL/SQL The PL/SQL permits you to declare constants and variables, and then use them in SQL and procedural statements anywhere in the expression. Th