EXECUTE privilege is used to call a subprogram directly - PL/SQL Subprograms

Q.  To call a subprogram directly, users must have the EXECUTE privilege on that subprogram. By granting the privilege, you allow a user to -
- Published on 09 Jul 15

a. Call the subprogram directly
b. Compile functions and procedures that call the subprogram
c. Both A & B
d. None of the above

ANSWER: Both A & B
The EXECUTE privilege is a schema object privilege for procedures. It is granted to the users who execute or compile a procedure which calls it.

Post your comment / Share knowledge

Enter the code shown above:
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)