PrepAway - Latest Free Exam Questions & Answers

Which of the following statement(s) can be used to accomplish this?

User USER1 has the privileges needed to invoke a stored procedure named GEN_RESUME.
User USER2 needs to be able to call the procedure – user USER1 and all members of the group
PUBLIC should no longer be allowed to call the procedure. Which of the following statement(s)
can be used to accomplish this?

PrepAway - Latest Free Exam Questions & Answers

A.
GRANT EXECUTE ON ROUTINEgen_resume TO user2 EXCLUDE user1, PUBLIC

B.
GRANT EXECUTE ON PROCEDUREgen_resume TO user2;
REVOKE EXECUTE ON PROCEDURE gen_resume FROM user1, PUBLIC;

C.
GRANT CALL ON ROUTINEgen_resume TO user2 EXCLUDE user1 PUBLIC

D.
GRANT CALL ON PROCEDUREgen_resume TO user2;
REVOKE CALL ON PROCEDURE gen_resume FROM user1, PUBLIC;

One Comment on “Which of the following statement(s) can be used to accomplish this?


Leave a Reply