Which of the following commands correctly modifies Scott's rights on the bb_basket table?
A) GRANT SELECT, INSERT, UPDATE bb_basket TO scott;
B) GRANT SELECT, INSERT, ON bb_basket TO scott
C) GRANT SELECT, INSERT, UPDATE ON bb_basket;
D) GRANT SELECT, INSERT, UPDATE ON bb_basket TO scott;

Question

Quizplus · Accepted Answer

To modify Scott's rights on the bb_basket table to include SELECT, INSERT, and UPDATE privileges, we need to use the GRANT statement with the appropriate syntax. Option D is the correct syntax, as it grants SELECT, INSERT, and UPDATE privileges specifically to Scott on the bb_basket table. Option A and B have syntax errors, while option C only grants privileges without specifying which user should receive those privileges.

Which of the Following Commands Correctly Modifies Scott's Rights on the Bb_basket