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.
CRANT SELECT ON ADD_PLAYER TO PUBLIC;
B.
CRANT EXECTUE ON ADD_PLAYER TO PUBLIC;
C.
CRANT INSERT ON PLAYER TO PUBLIC;
D.
CRANT EXECTUE 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 AnswersA: 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.
pl