Oracle Database 12c Advance Adminstration1z0-063 Test 1

Question : 33 of 40

Marks: +1, -0

In your multitenant container database (CDB) that contains pluggable databases (PDBs), the hr user executes the following commands to create and grantprivileges on a procedure:

CREATE OR REPLACE PROCEDURE create_test_v(v_emp_idNUMBER,v_enameVARCHAR2, v_SALARYNUMBER,v_dept_idNUMBER) 
 BEGIN 
 INSERT INTO hr.test VALUES (v_emp_id, v_ename, v salary, v_dept_id); 
 END; 
 / 
 GRANT EXECUTE ON CREATE_TEST TO John, jim, smith, king;

How can you prevent users having the execute privilege on the create_test_v procedure from inserting values into tables on which they do not have any privileges?

Create the create_test procedure with definer's rights.
Grant the execute privilege to users with grant option on the create_test procedure.
Create the create_test procedure with invoker's rights.
Create the create_test procedure as part of a package and grant users the execute privilege on the package

Validate

Go to Question:

Prev Question

Next Question