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?
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;