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
Conditionals - SQL At first sight SQL does not appear to have a single operator for expressing logical implication. In this respect it would be in common with most programming

FOR-LOOP While the number of iterations through a WHILE loop is unknown till the loop completes, then the number of iterations through a FOR loop is known before the loop is ent

Understanding Varrays The Items of type VARRAY are termed as the varrays. They permit you to relate a single identifier with the whole collection. This relationship lets you man

TYPES OF EVOLUTION - Sequential evolution                  :                    Minor changes in the gene pool of a population from one generation to the next, with the resul

Many of the reports generated from the system calculate the total dollars in purchases for a shopper. Complete the following steps to create a function named TOT_PURCH_SF that acce

Using FORALL and BULK COLLECT Together You can unite the BULK COLLECT clause with the FORALL statement, in that case, the SQL engine bulk-binds column values incrementally. In

Question: Consider the following relations (primary keys are underlined): AUTHOR (ANo, aname, address, speciality) PUBLISHER (PNo, pname, Location) BOOK (BNo, Title, ISBN,

%ROWCOUNT The %ROWCOUNT yields the number of rows affected by the INSERT, UPDATE, or DELETE statement, or returned by a SELECT INTO statement. The %ROWCOUNT yields zero when a

Negation (NOT, ¬) - SQL There are three rows instead of just two. As you can see, ¬ p is defined as in two-valued logic (2VL) when p is either true or false, but ¬ (unknown) i

IN Operator The operator IN tests the set membership. This means "equal to any member of." The set may have nulls, but they are ignored. For illustration, the statement below do