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 control INSERT access via a procedure: (1) GRANT EXECUTE on the procedure to PUBLIC so users can call it, and (2) REVOKE INSERT on the table from PUBLIC to prevent direct inserts. The procedure then becomes the only insertion path. Options A and C grant wrong privileges. Option D grants INSERT on the procedure (incorrect - procedures aren't inserted into).

Keep practicing — related questions