A user wishing to invoke an SQL stored procedure that queries a table must have which of the
following privileges?
A.
CALL privilege on the procedure; SELECT privilege on the table
B.
CALL privilege on the procedure; REFERENCES privilege on the table
C.
EXECUTE privilege on the procedure; SELECT privilege on the table
D.
EXECUTE privilege on the procedure; REFERENCES privilege on the table
CALL statement invokes a stored procedure.
Invocation
Authorization
Invoking a stored procedure requires the EXECUTE privilege on stored procedure
0
0
EXECUTE Package, Procedure, Function, Method Allows users to execute packages and
routines.
SELECT Table, View Provides the ability to view the contents of the
object using the select statement.
0
0