How can you prevent users having the EXECUTE privilege on the CREATE_TEST…

In your multitenant container database (CDB) containing pluggable database (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 n

In your multitenant container database (CDB) containing pluggable database (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 n

A.
Create the CREATE_TEST procedure with definer’s rights.

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

C.
Create the CREATE_TEST procedure with invoker’s rights.

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



Leave a Reply 0

Your email address will not be published. Required fields are marked *