Answer-first summary for fast verification
Answer: Combines the abilities to add, delete, and modify data in the table
The MODIFY privilege comprehensively grants the ability to add, delete, and modify data in a table. This ensures that the grantee can perform all necessary data manipulation operations on the specified object. For more details, refer to the [Databricks documentation on object privileges](https://docs.databricks.com/security/access-control/table-acls/object-privileges.html#privileges).
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
What capabilities does the MODIFY privilege grant when a data engineer executes the SQL query: GRANT MODIFY ON TABLE employees TO hr_team?
A
Enables the addition of data to the table
B
Allows the deletion of data from the table
C
Permits the modification of existing data within the table
D
Combines the abilities to add, delete, and modify data in the table
E
None of the options accurately describe the MODIFY privilege's capabilities
No comments yet.