Oracle Exam 1Z0-060 Topic 2 Question 56 Discussion

Actual exam question for Oracle's 1Z0-060 exam

Question #: 56
Topic #: 2

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

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

ACreate the CREATE_TEST procedure with definer's rights.

BGrant the EXECUTE privilege to users with GRANT OPTION on the CREATE_TEST procedure.

CCreate the CREATE_TEST procedure with invoker's rights.

DCreate the CREATE_TEST procedure as part of a package and grant users the EXECUTE privilege the package.

Show Suggested Answer

Suggested Answer: C

by Dalene at Mar 20, 2023, 08:24 PM

Limited Time Offer

25%

Off

Get Premium 1Z0-060 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!