Answer-first summary for fast verification
Answer: GRANT MODIFY ON TABLE table_name TO john.smith@marketing.com
The correct command to grant update access is `GRANT MODIFY ON TABLE table_name TO john.smith@marketing.com`. This command specifically allows the user to modify the table, which includes updating its contents. For more details on table privileges, refer to the [Azure Databricks documentation](https://docs.microsoft.com/en-us/azure/databricks/security/access-control/table-acls/object-privileges#privileges).
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
John Smith, a new member of the Marketing team, currently has read access to sales tables but lacks the permission to update them. Which command would you use to grant him update access?
A
GRANT USAGE ON TABLE table_name TO john.smith@marketing.com
B
GRANT MODIFY ON TABLE table_name TO john.smith@marketing.com
C
GRANT UPDATE TO TABLE table_name ON john.smith@marketing.com
D
GRANT UPDATE ON TABLE table_name TO john.smith@marketing.com
E
GRANT MODIFY TO TABLE table_name ON john.smith@marketing.com