To successfully compile a program, you must either own the object or you must be granted the ____ privilege to compile an object in another schema.
A) ANALYZE_OBJECT
B) ALTER
C) MODIFY PROCEDURE
D) ALTER ANY PROCEDURE

Question

Quizplus · Accepted Answer

To compile an object in another schema, you must have the ALTER ANY PROCEDURE system privilege. This privilege allows you to modify any procedure, function or package in any schema. ANALYZE_OBJECT and MODIFY PROCEDURE are not valid privileges in Oracle. ALTER privilege only allows you to modify objects in your own schema.

To Successfully Compile a Program, You Must Either Own the Object