試題詳解

QUESTION 104 You have created a stored procedure DELETE_TEMP_TABLE that uses dynamic SQL to remove a table in your schema. You have granted the EXECUTE privilege to user A on this procedure. When user A executes the DELETE_TEMP_TABLE procedure, under whose privileges are the operations performed by default?
(A) SYS privileges
(B) Your privileges
(C) Public privileges
(D) User A's privileges
(E) User A cannot execute your procedure that has dynamic SQL.