Multiple choice technology databases

All users currently have the INSERT privileges on the PLAYER table. You want only your users to insert into this table using the ADD_PLAYER procedure. Which two actions must you take? (Choose two)

  1. a) GRANT SELECT ON ADD_PLAYER TO PUBLIC;

  2. b) GRANT EXECUTE ON ADD_PLAYER TO PUBLIC;

  3. c) GRANT INSERT ON PLAYER TO PUBLIC;

  4. d) GRANT EXECUTE, INSERT ON ADD_PLAYER TO PUBLIC;

  5. e) REVOKE INSERT ON PLAYER FROM PUBLIC;
Reveal answer Fill a bubble to check yourself
B,E Correct answer
Explanation

To force inserts through the procedure only: (B) grant EXECUTE on the procedure to PUBLIC so users can call it, and (E) revoke direct INSERT privileges on the table so users cannot bypass the procedure. Option A would allow reading the procedure code, not executing it. Option C is the opposite of what's needed. Option D is redundant - EXECUTE alone suffices.

Keep practicing — related questions