View the Exhibit and examine the structure of the departments table in SCOTT’s schema.
Examine the following block of code:
CREATE OR REPLACE PROCEDURE add_dept(
p_id NUMBER, p_name VARCHAR2) IS
BEGIN
INSERT INTO departments VALUES <p_id, p_name, NULL, NULL);
END;
/
The above procedure is created by user SCOTT. Another user JONES needs to use the procedure.
Which two statements are true in the above scenario? (Choose two.)
A. JONES executes the procedure with definer’s rights.
B. JONES executes the procedure with invoker’s rights.
C. SCOTT should grant only the execute privilege for the procedure to JONES.
D. SCOTT should grant both the BXKCOTE privilege for the procedure and insert privilege for the table to
I also think correct answers are AC:
https://docs.oracle.com/database/121/DBSEG/dr_ir.htm#DBSEG659
“By default, all procedures are considered definer’s rights. You can designate a procedure to be an invoker’s rights procedure by using the AUTHID CURRENT_USER clause when you create or modify it, or you can use the AUTHID DEFINER clause to make it a definer’s rights procedure.”