题目内容

The HR user creates a stand-alone procedure as follows and grants the EXECUTE privilege on theprocedure to many database users: CREATE OR REPLACE PROCEDURE create_dept ( v_deptno NUMBER, v_dname VARCHAR2, v_mgr NUMBER, v_loc NUMBER) BEGIN INSERT INTO hr.departments VALUES (v_deptno, v_dname, v_mgr, v_loc); END; The users having permission to execute the procedure are able to insert records into the DEPARTMENTStable even though they do not have the INSERT privilege on the table. You want only those users whohave privileges on the DEPARTMENTS table to be able to execute the procedure successfully. What would you suggest to the PL/SQL developers to achieve this()

A. Create the procedure with definer’s right.
B. Create the procedure with invoker’s right.
C. Grant the EXECUTE privilege with GRANT OPTION on the procedure to selected users.
D. Create the procedure as part of a PL/SQL package and grant the EXECUTE privilege on the package to selected user

查看答案
更多问题

通知和通报都可以用于传达情况和告知事项,但通知传达的是重要情况,告知的是特殊情况;而通报传达的是上级指示,告知的往往是一般事项。

A. 正确
B. 错误

客户购买理财产品时需接受风险承受力测评。

A. 正确
B. 错误

抗心律失常药物的分类,每类各举一代表药。

当疑似有新城疫发生时,应从发病禽或死亡禽采集哪些病料进行检测?病料如何保存?

答案查题题库