To ensure that only your users can insert into the PLAYER table using the ADD_PLAYER procedure, you need to take the following two actions:
B) GRANT EXECUTE ON ADD_PLAYER TO PUBLIC: This grants the public role the permission to execute the ADD_PLAYER procedure.
E) REVOKE INSERT ON PLAYER FROM PUBLIC: This revokes the insert privilege on the PLAYER table from the public role, ensuring that only your users can insert into the table.
Let's go through each option to understand why it is correct or incorrect:
A) GRANT SELECT ON ADD_PLAYER TO PUBLIC: This grants the public role the permission to select data from the ADD_PLAYER procedure. However, this does not restrict the insert privilege on the PLAYER table, so it is not necessary for achieving the desired outcome.
B) GRANT EXECUTE ON ADD_PLAYER TO PUBLIC: This option is correct because it grants the public role the permission to execute the ADD_PLAYER procedure. This allows all users to execute the procedure, which is necessary for inserting into the PLAYER table using the procedure.
C) GRANT INSERT ON PLAYER TO PUBLIC: This grants the public role the insert privilege on the PLAYER table. However, this does not ensure that only your users can insert into the table using the ADD_PLAYER procedure, so it is not necessary for achieving the desired outcome.
D) GRANT EXECUTE, INSERT ON ADD_PLAYER TO PUBLIC: This grants the public role the permission to execute the ADD_PLAYER procedure and the insert privilege on the ADD_PLAYER table. However, it does not restrict the insert privilege on the PLAYER table, so it is not necessary for achieving the desired outcome.
E) REVOKE INSERT ON PLAYER FROM PUBLIC: This option is correct because it revokes the insert privilege on the PLAYER table from the public role. This ensures that only your users can insert into the table using the ADD_PLAYER procedure.
Therefore, the correct answer is B) GRANT EXECUTE ON ADD_PLAYER TO PUBLIC and E) REVOKE INSERT ON PLAYER FROM PUBLIC.