Explanation:
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.
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.