All users currently have the INSERT privilege on the PLAYER table. You only want your users to
insert into this table using the ADD_PLAYTER procedure. Which two actions must you take?
(Choose two)
A.
GRANT SELECT ON ADD_PLAYER TO PUBLIC;
B.
GRANT EXECUTE ON ADD_PLAYER TO PUBLIC;
C.
GRANT INSERT ON PLAYER TO PUBLIC;
D.
GRANT EXECUTE,INSERT ON ADD_PLAYER TO PUBLIC;
E.
REVOKE INSERT ON PLAYER FROM PUBLIC;
Explanation:
B: You must provide the users with EXECUTE privilege to the procedure.
E: You want to restrict access to the underlying table so you REVOKE the INSERT privilege to
PUBLIC.
Incorrect Answers:
A: You can’t GRANT the SELECT privilege to a procedure
C: Users already have this privilege, you want to REVOKE this privilege.
D: You can’t GRANT an INSERT privilege to a procedure, the EXECUTE privilege is correct.