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