Explanation:
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.
Ultimate access to all questions.
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
No comments yet.