Answer-first summary for fast verification
Answer: GRANT MODIFY ON TABLE inventory TO tom.hanks@organization.com
The `GRANT` command is used to assign specific privileges on a securable object to a principal. The correct syntax for granting permissions is `GRANT privilege_types ON securable_object TO principal`. In this scenario, `MODIFY` is the privilege type that encompasses both insert and delete operations on the `inventory` table for the principal `tom.hanks@organization.com`. Therefore, the correct command is `GRANT MODIFY ON TABLE inventory TO tom.hanks@organization.com`.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
Tom Hanks, a new member of the data analysis team, has read access to the inventory table but lacks permissions to insert or delete rows. Which command grants him these additional permissions?
A
GRANT INSERT, DELETE TO tom.hanks@organization.com ON TABLE inventory
B
GRANT USAGE ON TABLE inventory TO tom.hanks@organization.com
C
GRANT MODIFY TO tom.hanks@organization.com ON inventory
D
GRANT INSERT, DELETE ON TABLE inventory TO tom.hanks@organization.com
E
GRANT MODIFY ON TABLE inventory TO tom.hanks@organization.com
No comments yet.