题目内容

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: CREATE OR REPLACE PROCEDURE create_test_v (v_emp_id NUMBER, v_ename VARCHAR2,v_SALARY NUMBER, v_dept_id NUMBER) 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 procedure from inserting values into tables on which they do not have any privileges?()

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.
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.

查看答案
更多问题

开采矿产资源,必须遵守国家劳动安全卫生规定,具备()的必要条件。

一方为国内公民,另一方为华侨或港澳同胞的婚姻,即可认为是涉外婚姻。

A. 正确
B. 错误

在颜色中分为非彩色和彩色两类,通常情况下将()的颜色设置为非彩色

A. 主要内容文字
B. 边框
C. 背景
D. 图片

国家电网公司《营销稽查监控系统业务模型说明书》对数据质量监控如何定义?

答案查题题库